Aggregates whereused

[Former Member]

Hi ,

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

Thanks,

S

[Former Member · Accepted solution]

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.

[Former Member · Accepted solution]

Thanks john- Its very informative.

I just had a requirement that I need to document all the aggregates I created and reflected queries on performnace improvement.

[Former Member]

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

[Former Member]

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

OOPS...RSRT not RSRV...

Guarav

Message was edited by: Gaurav

[Former Member]

Try table RSDDSTATAGGR.

Also try other tables starting with RSDDSTAT* .

Hope it helps,

Farhan