I have a simple InfoCube and query. The InfoCube & Query has 0MATERIAL. I've created an aggregate that only has 0FISCPER & 0MATERIAL. When I execute the query in RSRT, then look at the Last Used in Maintain Aggregates, I can see that is does not hit the aggregate. However, when I run the same query in RSRT, but this time do Execute + Debug, I see where it hits the aggregate in the Last Used column of the Aggregate screen.
I have tried this several ways, confirmed that my cube has the data I am looking for, for when I put in a specific value in 0MATERIAL variable. It doesn't make sense to me that in RSRT, Execute & Execute + Debug would work differently.
Please offer any ideas. Thanks, Keith J