How do you calculate the size of the DataBlock?

How do you calculate the size of the DataBlock?
Who is Participating?
garycrisConnect With a Mentor Commented:
In order to calcualte the size of a data block you first determine the number of cells in each block.  There is one cell for each dense dimension, stored member, combination.

So if you have a Time dim that is Dense and has the following Stored Members


And and Accounts dimension that is Dense with the following Stored members


You would have 16 unique combinations (4 x 4) Take note I included the root members of the dimension as they are stored members in this example.  In real world, many of my upper level members in dense dimensions would be dynamic calc or label only, meaning they are not stored and therefore would not be considered when calculating my block size.  This is a way to optimize my outline and keep my blocks smaller.
So if I have 16 cells, each cell is 8 bytes.  Therefore my block size would be 128 bytes (16 cells x 8 bytes per cell)

If I had a third dense dimension with 10 stored members then I would simply add to my calc
 4 x 4 x 10 = 160 cells x 8 bytes = 1280 bytes.

Notice how my block size gets exponentially larger as I add additional dense dimensions.  Be aware of this and choose your dense dimensions carefully.
AJITPADHYAuthor Commented:
AJITPADHYAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.