Aggregate have High Record Summarised (>10) But NOT Used
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.