Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Aggregate have High Record Summarised (>10) But NOT Used

Hi

I Have found the Query/Infocube which is taking high DB time(>30 %) and High Select/transfer Ration (>10) . From Table RSDDSTAT I found out the STATUID of the High Response time Query and put the STATID in the table RSDDSTATAGGRDEF to get the IOBJNM .

Then Created the Aggregates Based on these IOBJNM , Query Definitions and General Rules for creating aggregates.

The Aggrgate Created have high Record Summarised(mean Value) >10 but these Aggregates are NOT used by the Query .

Please tell me how to Debug WHY the Query is NOT using the Aggregates.

I found out the Quesry is NOT using the Aggregates when I run the Query in DEBUG mode in Transaction RSRT.

I want to increase the Performance of the System. Please help me to find out where I am going wrong ? Why the Query is Not selecting the Aggregate.

Kind regards,

Yogesh

Not what you were looking for? View more on this topic or Ask a question