Problem Creating Precaclulated Web Template Data with variable

37 Views

Our objective is to create weekly static reports (i.e. the report for that week never changes over time even if new data for that week is loaded into the Infocube). The approach we've taken is the use of query with a selection variable in a web template with data_mode=static.

The steps we've taken are:

1) created the query wit hone selection variable (ZWPSYWK).

2) created the simple web template with this query, with setting data_mode=stored.

3) Created the Reporting Agent setting

4)Created the Reporting Agent scheduling package

5)Ran the reporting agent with variant : ZWPSYWK = 200501

6)I was then able to see data using the URL http://xxxxxxxxx/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&TEMPLATE_ID=ZWPS_PRECALC_INVESTIGATION&VAR_NAME=ZWPSYWK&VAR_VALUE_EXT=200501

7) Ran the reporting agent with variant : ZWPSYWK = 200502.

8) I was then able to see report data using the URL http://xxxxxxxxx/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&TEMPLATE_ID=ZWPS_PRECALC_INVESTIGATION&VAR_NAME=ZWPSYWK&VAR_VALUE_EXT=200502

9) However I was NOT able to see report data with URL http://xxxxxxxxx/sap/bw/BEx?sap-language=EN&bsplanguage=EN&CMD=LDOC&TEMPLATE_ID=ZWPS_PRECALC_INVESTIGATION&VAR_NAME=ZWPSYWK&VAR_VALUE_EXT=200501. I got the message No precalculated data found for data provider DATAPROVIDER_1

Any ideas ? Is it that the precacluated data for week 1 is gettign overwritten ? Can only one run of a precacluated web template be stored ? If so is this controlled by any setting ?