how to calculate d_cube size in analyst(is there any formula please send )

[anilkumar]

hi guys

thanks for advance help

how to calculate d-cube size in cognos planning analyst?

is there any formula ?
if it is there please let me know???

Regards
anil kumar

[StuartS]

If it is an existing cube, open the D-cube, selecting edit selection.  The diaog box that opens shows the number of cells.


To calculate you need to know the number of items in your d-lists.  Then multiply these, for example,

D-Cube that has two D-Lists.  One of 2 items and one of 3 items results in a D-Cube of 6 cells.

[mrobby]

Stuart is right.

Multiply the length of all of the dlists in the cube together to come up with the total number of cells in that cube.

[gidster]

Might just be worth adding that, depending on your PC specifications, there will be an upper limit to the Cube size.  I have found that up to approx 10million, everything should work OK.

Between 10m - 30m You will need to use Slice Updates on your cubes to make them work.

Over 30m...and for sure over 40m, you risk your cubes going corrupt on you (a very bad thing, especially if they are the source of lots of D-Links).  As once your cube goes corrupt, there is pretty much nothing you can do but rebuild it from scratch!

[blackadder]

Tip to improve cube performance in Analyst

DCube/Options/Stored Copy

Turn it off and Analyst no longer holds the old version of the cube open while you edit the new one.

But you lose a safety net: the ability to use the Reset command, and changed cells are no longer colour-coded, so you need to be confident in what you are doing.

This tip does not apply to Contributor.