If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Pre-aggregate Dynamic Cubes?

Started by Joern, 19 Nov 2015 01:44:00 AM

Previous topic - Next topic

Joern

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.


bus_pass_man

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.

Joern

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.