Finding Which Queries are Using Aggregates

[Former Member]

Hi,

I would like to know which specific queries are hitting the aggregates I have created. How can I achieve this?

Thanks,

Rachita.

[Former Member]

Hi,

1) Go to RSRT transaction in BW.

2) There, you select the query on a cube where you created an aggregate.

3) Click the "Execute + Debug" button; you will be presented with checkboxes.

4) Select "Show Aggregate Used." Also, check "No cache."

5) Now click the tick mark.

It will show you how many aggregates are there for the cube and how many aggregates are used for the particular query used.

ALSO:

Goto table RSDDSTAT. This shows every navigational step for a query and which aggregate it used

Reward points if found helpfull..

Cheers,

Chandra Sekhar.