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".