SAP Knowledge Base Article - Public

3487515 - Prompts screen shows the initial default value for a variable when being re-opened, although it was changed before.

Symptom

A SAC report with BW Live data source is ran. During initial loading, a prompt screen is shown in which you have a variable with some pre-filled value. Upon changing that pre-filled value and executing, then re-opening the prompts screen the variable is again filled with the value that also showed up initially, it is not filled with the value that was used for execution.

Environment

SAC BW Live

Reproducing the Issue

1) Run a report in SAC, which shows BW Live data.
2) On startup a prompts screen with a variable is shown, that has a pre-filled value.
3) Change the pre-filled value and run the report
4) The report shows properly filtered data, according to the changed variable value.
5) Re-open the prompts screen.
6) In the prompts screen the variable again shows the initial value, not the current value.

Cause

The designer of the BW query can choose between two refresh types for variables:
1) Dynamically
2) As Designed

Type 1) is the default refresh type and the variable should show the currently selected value. Type 2) means to not re-use the current state but reprocess the variable according to the query definition. E.g. a customer exit will be run again, and the variable will be filled with the initial value again.

Resolution

In the BEx Query Designer/Modelling Tool select the variable refresh type, which fits to your requirements. E.g. in the Modelling Tools you can find the property "Refresh Variables" when selecting the dimension/characteristic and expand the "Extended" section.

See Also

https://help.sap.com/docs/SUPPORT_CONTENT/bwplaolap/3361382573.html

Keywords

Refresh Variables, As Designed, Dynamically, Prompts, BW Live, customer exit, input ready , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-OLAP-VAR , Using Variables , BW-BEX-OT-BICS-INA , BW INA provider , How To

Product

SAP Analytics Cloud 1.0