Block size & Number of potential blocks

Datablock is a place which is used to store actual values in Essbase cube.The actual data are stored in the format of page files(.pag file type) and these files are located on Server drives.

Dense Data blocks are created for each combinations stored member of dense dimensions.

Caluculate Block size:

In Sample.Basic, it has 3 dense dimensions (Years,Measures & Scenario).Year,Measures & scenario contains 12,8 & 2 stored members respectively.

So, Number of cells are 192 (12*8*2).

Syntax :
 

Block Size =( No of stored members of Dense1*No. of  stored members of Dense2.. )*8kb

    

For detail information see below.

As per above figure block size is calculated as follows.

Block size = (12*8*2)*8 =1536 in bytes

Calculate Potential Blocks:

Essbase creates a data block for each unique combination of sparse standard dimension members (providing that at least one data value exists for the sparse dimension member combination). The data block represents all the dense dimension members for its combination of sparse dimension members.Essbase creates an index entry for each data block. The index represents the combinations of sparse standard dimension members. It contains an entry for each unique combination of sparse standard dimension members for which at least one data value exists.

 

From the above figure. We can calculate the No of potential blocks.

Syntax :

No of potential blocks = (No.of stored members of Sparse1* No.of stored members of Sparse2...)

In the above figure Sample.Basic have 2 sparse dimensions namely Market and product. Number of stored members are 18 & 25 respectively.

Number of potential blocks = 18 * 25 = 475 blocks