Database table in Report Agent

[Former Member]

In Report Agent Seetings -> Parameter Tab, there are four types for pre-calculation selection. I have used HTML for Web and Excel. Both work nicely. I would like to use the database table for exporting query results. However, I cannot find any documentation about where these tables are located or what are their naming convention. Anyone can help me on this?

Thanks a lot!

Bill

[Former Member]

Hi Bill,

did you read the documentation http://help.sap.com/saphelp_bw33/helpdata/en/a0/a48b3ba19dfe47e10000000a11402f/frameset.htm data_mode stored?

Just some remarks: Precalculation of data has not been implemented to export query results.

This is more an internally used function. The data is not stored in a transparent table, but in a cluster table (I think the name of the cluster table is rsixwww)

Heike

[Former Member]

Hi Heike,

Thanks a lot for your reply. For some reasons, I cannot access the documentation you refered. However, I did find DATA_MODE and the following info for Pre-calculate Data from the BW 3.0 Online CD:

Accessing pre-calculated data leads to a marked improvement in performance: The data is no longer requested from the OLAP processor, and only the HTML pages must be generated.

With complex queries with

complex selection criteria

TopN conditions

calculated indicators

We recommend that you pre-calculate the data.

Combined with your remarks, I understand that the purpose of this Data table is to stage data for futher process such as HTML pages regeneration when DATA_MODE is set to STORED in URL.

Once again, thank you very much!

Bill