Nonconstant Values
If you assign anything other than a constant to a member in a sparse dimension, and no data block exists for that member, new blocks may not be created unless Essbase is enabled to create blocks on equations. By default, Create Blocks on Equations is disabled in block storage cubes.
For example, to create blocks for West that did not exist before running the calculation, you would need to enable Create Blocks on Equations for this formula:
West = California + 120;Note:
If Create Blocks on Equations is disabled for a database and data blocks exist for members on either the left- or right-side of the equation, the formula produces results.
You can enable Create Blocks on Equations as a setting at the database level, whereby blocks are always created, or you can control block creation within calculation scripts using the SET CREATEBLOCKONEQ calculation command.
As unnecessary blocks can be created when Create Blocks on Equations is enabled at the application or database level, calculation performance may be adversely affected. Thus, it may be preferable to control block creation at the calculation script level. Refer to Nonconstant Values Assigned to Members in a Sparse Dimension.
To enable Create Blocks on Equations for all calculation scripts on a block storage cube, you can use the alter databaseMaxL statement with the enable create_blocks clause.