How to Increase Cube Size Cognos Can Open

[Hector]

Hi,

Sadly due to business demand we have a few 25-32 million cell Cubes. (Cognos EP 10.1)

Some of these Cubes are now struggling because they are heavily populated with data, especially by the time we reach the end of the financial year.

We are not using Contributor, Analyst only. We currently use Slice Updates, etc.. Does anyone have advice which would allow us to run these Cubes. I.e. Increase Maximum Workspace Size (Currently 512MB), Increase Client RAM (Currently 3GB) not sure about server as I do not have the details yet.

[ericlfg]

Hi Hector,

You can be pretty dynamic with the workspace sizing.  You can go up to about a maximum of 900MB for the workspace, but I would not recommend going any further, regardless of how much ram is available.  Since planning is a 32bit application, 2GB is about the limit for the dyalog32 process.

However, in your case, you will want to try lowering the workspace setting since the dcube data is stored outside the workspace.

Example:
You have 2GB for the dyalog process, and you have your workspace set to 512MB, this leaves ~1500MB for cubes.  So, if you lower the workspace size to 256MB, you'll have ~1750MB for dcube data.

The only other alternative is to trim out dimension members that increase the size of the cube dramatically, such as version years.

[Hector]

Thanks ericlfg,

I did not know that. What negatives will we potentially see from reducing the workspace from 512MB to 256MB? Macros run slower? Or will Macros run faster because there is 1750MB free?

Thanks,

H

[ericlfg]

You may see that dlinks won't run, as they are contained within the workspace sizing, but this is dependent on how much data is being moved with them.  This is why the setting needs to be played with for the optimal configuration in your environment.