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

Aggregates & clearing cache problem

38 Views

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

Thanks,

Eduard

Message was edited by: E. Brantjes

Message was edited by: E. Brantjes

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