Showing results for 
Search instead for 
Did you mean: 

Aggregate usage

Former Member
0 Kudos


I have a query built on an infocube and I designed an aggregate exclusively for this query. Aggregate contains all the necessary fields in it.

A NAV attribute is used in the query and restricted on a hierarchy. Did exactly the same in the aggregate also. But, I am encountering a strange behavior.

When I put that NAV attribute in either the "free characteristics" box or the "filter", the query uses the aggregate. But when I move that NAV attribute to the "rows" box, query does not read the aggregate.

The read mode for data is set to "H Query to read when you navigate or expand hierarchies".

Any explanation?



Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos


you can test this behaviour by using the transaction RSRT --> execution + debugger, flag the usage of aggregates.

After executing the system shows you the needed vs. the founded aggregate. With this information it is possible to give you an explanation.

kind reg.


ps. If the answer helps, please assign points. Thanks.