The Number of Cells in a Logical Block

The term logical block refers to an expanded block in memory.

  To determine the cell count of a logical block, multiply all members of each dense dimension (including Dynamic Calc and Dynamic Calc and Store members but excluding Label Only and shared members):

  1. Using Table 251 as a worksheet, enter each dense dimension and its number of members, excluding Label Only and shared members. If there are more than seven dense dimensions, list the dimensions elsewhere and include all dense dimensions in the calculation.

    Table 251. Worksheet: The Number of Cells in a Logical Block

    Dense Dimension Names

    Number of Members

    This image of a space is used for formatting purposes only.

    a.This image of a space is used for formatting purposes only.

     

    b.

     

    c.

     

    d.

     

    e.

     

    f.

     

    g.

  2. Multiply the number of members of the first dense dimension (line a.) by the number of members of the second dense dimension (line b.) by the number of members of the third dense dimension (line c.), and so on, to determine the total number of cells in a logical block:

    a * b * c * d * e * f * g = total number of cells

    Write the result to the cell labeled MI in Table 249, Worksheet: Factors Used to Calculate Database Memory Requirements.

Example

Excluding Label Only and shared members, the dense dimensions in Sample.Basic contain 17 (Year), 14 (Measures), and 4 (Scenario) members. The calculation for the cell count of a logical block in Sample.Basic:

17 * 14 * 4 = 952 cells