I have a customer exit in place for a variable ZFISCYEAR and 0FISCPER in the query designer. [BW730 SP10]. The requirement is that the default value which should appear, for these variables should be of the previous year. This works fine when I am directly running the query in BEx Analyzer.
For example: When one runs a report in year 2014, he should see a value of 2013.
However when I run the work book for the same query, the value which comes for the variable is the value present in the Workbook, at the time of saving it.
If the Workbook was saved in the 2014 and when I run the report get value 2014 and not 2013. Same problem for 0FISCPEAR.
Workbook select "Refresh workbook on Open" and in the table RSADMIN insert the parameter RSPLF_RESET_VAR_CONT with VALUE = X.