You can enable Two-Pass calculation for databases for which you have Database Manager permissions. When Two-Pass calculation is enabled, during second calculation passes, Essbase recalculates members that are dependent on the calculated values of other members.
Note: | This functionality does not apply to aggregate storage databases. |
This feature is enabled by default. Changes to the Two-Pass setting become effective immediately after you click Apply.
To enable Two-Pass calculation:
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 Two-Pass calculation.
Click Apply.
“Using Two-Pass Calculation” in the Oracle Essbase Database Administrator's Guide
“Defining Calculation Order” in the Oracle Essbase Database Administrator's Guide
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