Set the Default Calculation

By default, the calculation for an Essbase block storage database is a CALC ALL of the database outline. CALC ALL consolidates all dimensions and members and calculates all formulas in the outline.

You can, however, specify any calculation script as the default calculation. You can assign a frequently used calc script to the database rather than loading the script each time you want to perform its calculation. If you want a calculation script to work with calculation settings defined at the database level, you must set the calculation script as the default calculation.

To set the default calculation, you can use the alter database MaxL statement with the set default calculation clause. Example:

alter database Sample.Basic set default calculation 'calcscriptname';