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

Aggregates whereused

Hi ,

Is there any table which tells where( or in what queries) the particular aggregate is used.

Thanks,

S

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 24, 2006 at 06:34 PM

    Hello,

    Its not possible to evaluate whether a query will use an aggregate beforehand. There are a few reasons for this:

    1) The same query can use an aggregate AND also cannot use an aggregate depending on the selection criteria in the report. (e.g. The aggregate does not contain COMP_CODE, but the user selects COMP_CODE as an optional variable occasionally)

    2) For each query, there can be multiple sub queries issued. Some of the subqueries may use an aggregate and some may not. (e.g. your query issues 6 subqueries, 3 use the aggregate and 3 do not)

    The best way to find out is execute and debug the query in RSRT and check 'display aggregate' tickbox.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 23, 2006 at 09:03 PM

    Try table RSDDSTATAGGR.

    Also try other tables starting with RSDDSTAT* .

    Hope it helps,

    Farhan

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 23, 2006 at 11:38 PM

    You can also try RSRV to see that query uses Aggregate or not...

    OOPS...RSRT not RSRV...

    Guarav

    Message was edited by: Gaurav

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 24, 2006 at 06:40 PM

    Hi,

    You can use RSRT to find out if the query uses and aggregate or not. You can get the aggregates list in the RSDD* tables but you won't be able to say for sure that the query is using the aggregate or not. Aggregates might be built for a query or are not filled and not used, or if the query is running against some other selection than on which the aggregate is built up, it won't use the aggregate at the time of execution.

    Cheers,

    Kedar

    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.