Skip to Content
author's profile photo Former Member
Former Member

Database table in Report Agent

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!


Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2003 at 08:43 PM

    Hi Bill,

    did you read the documentation               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)


    Add comment
    10|10000 characters needed characters exceeded

    • 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!