Finding Which Queries are Using Aggregates

Former Member — Sat, 26 Jan 2008 13:41:28 GMT

Hi,

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

Thanks,

Rachita.

Re: Finding Which Queries are Using Aggregates

Former Member — Sun, 27 Jan 2008 09:42:55 GMT

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.