Calculating Data Block Size and Number of Data Blocks

Calculating Data Block Size and Number of Data Blocks

Consider the following dimensions are presented in the outline of the Essbase Cube.

 In that Dense dimensions are below,
  Net Income
  + Income (Stored)
  + Expenses (Stored)

Qtr 1
  + Jan (Stored)
  + Feb (Stored)
  + Mar (Stored)

Version
  ~ Actual (Stored)
  ~ Budget (Dynamic)
  ~ Forecast (Dynamic)

The Sparse dimensions are below.
Product
 + Shirts
 + Pants

Region
 + North
 + South
 + East
 + West

Note:
Example purpose, use this outline for the following questions

How to find out the Data Block Size in Essbase?

   The product of the stored members in the dense dimension *8

    Example: (Consider the above outline structure)

• Number of stored members in Net income dimension = 2
• Number of stored members in Qtr1 dimension = 3
• Number of stored members in Version dimension = 1

    The product of stored members in dense dimensions = 2*3*1 = 6

    Data Block Size = 6*8 = 48

How to find the possible number of blocks in Essbase?

   The Product of members in sparse dimension.

    Example: (Consider the above outline structure)   

• Number of stored members in Product dimension = 2
• Number of stored members in Region dimension = 4

    Possible number of blocks = 2*4 = 8

Note:
Each unique combination of sparse dimension creates a block.