The default calculation command for databases is CALC ALL. Thus, during full database calculations, Essbase consolidates all dimensions and members and all outline formulas.
For databases for which you have Database Manager permissions, you can specify any calculation script or calculation string as the default database calculation. For example, you can assign a frequently used script as the default, rather than load the script each time you want to run its calculation against the database.
Changes to the default-calculation setting become effective immediately.
Note: | This functionality does not apply to aggregate storage databases. |
To set the default calculations:
From Enterprise View or a custom view, select a database.
Right-click, and select Set, and then Default calculation.
In the Set Default Calculation dialog box, select the default calculation method.
Click OK.
alter database (MaxL) in the Oracle Essbase Technical Reference
setdefaultcalc (ESSCMD) in the Oracle Essbase Technical Reference
setdefaultcalcfile (ESSCMD) in the Oracle Essbase Technical Reference