I have a workbook with a query embedded in it. While opening the workbook it is not refreshing the variable using the value from the user exit. While I am executing the query it is working properly.
In workbook "Refresh Workbook on Open" is selected.
Query is working with following exit code (both step 1 & 2)
WHEN 'ZEXTICK_DT_YD'. "Yesterday based on system date
IF i_step = 1.
l_date = sy-datum - 1.
l_s_range-low = l_date.
l_s_range-sign = 'I'.
l_s_range-opt = 'EQ'.
APPEND l_s_range TO e_t_range.
We are in BI 7 and Support pack 15.
Thanks in advance