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

Is there a way to know that a Query is getting its data from an AGGREGATE?

Hi Experts,

when you create an aggregate, Is there a way to know that a Query is getting its data from an AGGREGATE instead of the cube?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2011 at 01:20 PM

    Hi,

    In my opinion, I think we cannot find it from the query, because it will always mention the cube name as the Info provider.

    But we can go to the back-end and in the cube you can check whether the data is getting rolled up to an aggreagate.

    If the data is getting put into some aggregate which has the same structure as the query, then we can say that the particular aggregate was used.

    Hope this helps.

    Regards,

    RahulM

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 14, 2011 at 01:55 PM

    Hi,

    You can check the Last Used Info in RSDDAGGRDIR table. You can find out whether the Query has hit the Aggregate or not......

    Regards,

    Suman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2011 at 01:57 PM

    Hi,

    try transcation RSRT, type in your query, choose the execute& debug modus with the flags on Display Aggregate Found and Select Aggregates. Then you can see, if the aggregate will be used and which characteristic is missing in your aggregate.

    Cheers.

    Jürgen

    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.