Hello,
I have just started working with dynamic cubes. We're on Version 10.2.1 + FP9.
I have succesfully build and published my first cube. But reports on it have a very bad performance. My fact table has about 60 millions records and I use currently (for testing) only a time dimension and a little dimension with about 50 members at the lowest level.
The first new query on the cube takes about 10 minutes, of course when I ran the same query again it is fast (data is coming from cache?). But the next different query again takes much to long.
I need to refresh my cubes every night, so the cache then becomes invalid.
Isn't there a way to preload the cache?
At the moment I don't see how to work with dynamic cubes in a production enviroment with daily changing data and with a high flexibility on the different cubes.
Quotedata is coming from cache?)
Yes.
QuoteIsn't there a way to preload the cache?
Yes, there is.
Download the IBM Dynamic Cube redbook. I think you will find the optimization chapter useful.
What sort of aggregate table and in-memory aggregate strategy are you using?
You should also look in to the uses of virtual cubes as part of your total application.
Hello,
I solve this with the advice from "bus_pass_man".
In the redbook "IBM Cognos Dynamic Cubes" in chapter 11.8, this topic is explained.