Enabling Create Blocks on Equations

If you assign anything other than a constant to a member of a sparse dimension and a data block does not exist for the member, you must enable Essbase to create blocks on equations. For databases for which you have Database Manager permissions, you can enable Essbase to create blocks on equations. Your selection becomes effective immediately after you click Apply.

Note:

This functionality does not apply to aggregate storage databases.

To enable Essbase to create blocks on equations:

From Enterprise View or a custom view, select a database.
Right-click, and select Edit, and then Properties.
In the Database Properties window, select the General tab.
Expand the Calculation node.
Select Create blocks on equations.
Click Apply.

Related Information

Database Properties Window—General Tab
“Constant Values Assigned to Members in a Sparse Dimension” in the Oracle Essbase Database Administrator's Guide

Related Commands

alter database (MaxL) in the Oracle Essbase Technical Reference
setdbstate (ESSCMD) in the Oracle Essbase Technical Reference
setdbstateitem (ESSCMD) in the Oracle Essbase Technical Reference
set createblockoneq (calculation command) in the Oracle Essbase Technical Reference