Skip to Content
Former Member
Oct 29, 2009 at 08:43 PM

RSRT - Execution inconsistency


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