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 a comment
10|10000 characters needed characters exceeded

Related questions

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


Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.