Which Aggregate was used for a particular query execution

[former_member198883]

Hi,

I want to find out that exactly which aggregate was used for a particular execution of a query in rsrt. I've tried the RSDDSTAT_DM view but it is not getting filled even after I changed the settings in T-Code RSDDSTAT.

Thank you.

[mohammed_omer4]

Hi Vivek,

The best way to check what aggreagte is the aggregate

the query is hitting is thru RSRT in Execute + Debug, and under 'Others' - check

'Display Statistics Data' + 'Do Not Use Cache'.

Now after viewing the report you get the statistics data - go to the 'Aggregation Layer' Tab.

If an aggregate was selected during execution - it's id will be under Aggregate column, Else

there will be the InfoProvider Name.