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