Skip to Content
0
Former Member
Jul 18, 2008 at 10:28 PM

How to Know if Aggregate is Hit other than usage column

35 Views

Hello Friends. I checked in ST03N it shows number of aggregate 3 . is there any other way or table that i can find out if my aggregate 10009 is hit when i run the query or not hit.

I checked maintain aggregate "usage column"

it is always 0 . what other way I can find if my aggregate is hit or not. please help.

I have build the simple aggregates so as per requirement I have dragged all the characteristics to aggregate that exist in filters and in rows of the query. Still I have no hits when i run the report in RSRT.

Please suggest whats should i do to fix this. Also there five minus on my aggregate since i have 87600 in my aggregate and 1 record of fact table form 1 record of aggregate

Please help me on this

Thanks

Soniya