BEx Query View - Variable Defaults
We are on BW 7.4 on HANA and have recently updated to SP10 (from SP06). Before updating to SP10, BEx query views with customer-exit variable defaults were properly translated (ie - Current month = NOVEMBER). However, since the SP update the variable defaults to the previously run value (ie - if I never change the variable value, it will always read NOVEMBER no matter which month we are actually in). Has anyone experienced this behavior or have a solution to fix it?
The BEx query properly translates the variable. Behavior only exists on query view (and locally saved workbooks).
Patricia Yang replied
You may refer to below KBA:
1852783 - Processing of Variables on Refresh
For customer exit variables in "default values" area in Query Designer, if you change the corresponding characteristic to "refresh as designed" in "extended" tab, the customer exit variable will be processed when BEx query views are executed.