Skip to Content

Precalculate all characteristics combinations of a BW query...

Hi All,

We need precalculate all possible characteristics combinations (drill downs) of a query to fill the BW cache.

Looking on the Reporting Agent it´s possible precalculate a bw query using another query to control the filters, however using this feature it is not possible to pass all the possible navigations steps of the query to the variant.

Anyone can help me with this issue?

Enrique.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 07:45 AM

    Hi Enrique,

    Arun has comletely right.

    Only one more thing: you can also set in Tcode RSRT in Properties the Session A - Query must read all values.

    Ciao.

    Riccardo.

    If it is all right please close the topic.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      The Query Read Mode set to: <b>A Query to Read All Data At Once</b> is the easiset way to handle this.

      If you review the SQL that is generated, you will see that all the Free Characteristics are selected in the query when this Read Mode is set.

      Keep in mind, that if this query has any input variables that users might change, those variables need to be set to Can be Changed During Navigation in order to have all their different executions of that query use the OLAP Cache.

      When you look at the query Prooperties, you may want to review the other related settings - Cache Mode and Persistence Mode.

  • Posted on Aug 03, 2006 at 05:21 AM

    Enrique,

    Welcome to SDN...

    What you need to do for the same is :

    Have all the characteristiics in the rows areas and then run the query in the background using reporting agent , this will fill up the OLAP cache and you can use the same.

    All the data resides in the cache and you can use the original query later and it would fetch the records from the cache.

    To check the same , activate the cache first

    Then run the fully detailed query

    Now run any other version of the query through BeX and then check in SM04 to see if you are fetching the records directly from the cube/ods or from the cache ( indicated by RSRCACHE)

    Arun

    Assign points if useful

    Add a comment
    10|10000 characters needed characters exceeded

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.