Skip to Content
Former Member
Dec 21, 2005 at 12:52 PM

Aggregates & clearing cache problem


Hi all,

We have a report on a multicube and this multicube combines data of 3 infocubes (with aggregates). When running this report via RSRT2 in debug-mode, you can see which aggregates it chooses. This all works fine.

The result of the report however, still show old data, even though the use of cache has been disabled and the aggregates have been freshly rolled up right after the dataload. I know aggregates have cache of themselves, but doesn't the rollup of an aggregate overwrite this cache?

So in short: Howcome the report still shows old cached data?

The temporary solution we have now is to empty the cache and roll up the aggregate again in the morning (data loads run at night), but this reduces the performance of all other reports aswell (as there is no cache initially).



Message was edited by: E. Brantjes

Message was edited by: E. Brantjes

BTW, running this report without cache and aggregates gives correct results.