Dirty Aggregate(s)... want to compare InfoCube with Aggregate

95 Views

We have InfoCubes with Navigational Attributes.

For performance reasons we have defined several Aggregates (which also includes the Navigational Attributes).

Our Navigational Attributes don't change very much, so in the Attribute Change Run we only process the "delta".

Today we found that a query showed us results that were absolutely wrong, specific on the Navigational Attributes.

With the query debugging tool we found that the problem was an aggregate. We got good results without using aggregates and wrong results with the use of aggregates. And we could determine which specific aggregate was the cause.

Now I can rebuild the aggregate. No problem.

But how can I be sure that only that one aggregate was "dirty" and not some more aggregates?

We don't want to make a monthly round in rebuilding aggregates for system time, logspace and other reasons.

<b>Question:</b>

Are there methods to compare the content of the InfoCube with their Aggregates??

Note: We don't want to discuss the integrity of SAP BW and/of Aggregates. The main cause this situation could arise is probably some bad watching of the loads (specially attribute change runs)...