Workbook is not filtering based on Exit Variable during refresh

Hi,

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.

ENDIF.

We are in BI 7 and Support pack 15.

Thanks in advance

nisha