cancel
Showing results for 
Search instead for 
Did you mean: 

Problem Creating Precaclulated Web Template Data with variable

Former Member
0 Kudos

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_INVESTI...

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

😎 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_INVESTI...

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_INVESTI.... 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 ?

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

The reporting agent will always overwrite the old data. You can create multiple variants in the repoting agent i.e for week1 week2 etc and run the reporting agent.

One more option to view the historic data is to create a bookmark for the report with the command bookmark_data. This will bookmark the report with the data availabl at that time you will be able to view later the same data. The documentation for this is available at the link given below:

http://help.sap.com/saphelp_nw04/helpdata/en/2e/23813b731fd60ee10000000a114084/content.htm

Thanks.

Answers (2)

Answers (2)

Former Member
0 Kudos

I've managed to resolve the problem. I'm still using a precalculated web template with the reporting agent. I need however to create a new setting for the web template and new scheduled package for each week (rather than editing the variabt for the same setting). That way any previous week's reports don't get overwritten.

Phil

Former Member
0 Kudos

Deepu,

Thanks for your suggestions.

Regarding adding each week into the variant, won't this have the problem of recalculating the previous weeks reports (something that our users don't want as they want the data in the report to remain fixed even though the data in the cube will change i.e. the report is "published")?

Can bookmarks be used to freeze the data in the report ? I though they only froze the navigational status.

Phil

Former Member
0 Kudos

When the reporting agent is run it is always using the current data in thge cube. As I had mentioned below the command URL "bookmark_data" will store historical data about the bookmark and "bookmark" will save the navigation state.