Setting the Default Calculation in Essbase

Setting the Default Calculation:

By default, the calculation for a 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 database calculation. Thus, you can assign a frequently-used 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, use a tool:

Tool	Topic	Location
Administration Services	Setting the Default Calculation	Essbase Administration Services Online Help
MaxL	alter database	Essbase Technical Reference
ESSCMD	SETDEFAULTCALCFILE	Essbase Technical Reference

Calculating Databases:
If you have Calculation permissions, you can calculate a database.
When you use Administration Services to calculate a database, you can execute the calculation in the background so that you can continue working as the calculation processes. You can then check the status of the background process to see when the calculation is complete.

To calculate a database, use a tool:

Tool	Topic	Location
Administration Services	Calculating Block Storage Databases	Essbase Administration Services Online Help
MaxL	execute calculation	Essbase Technical Reference
ESSCMD	CALC, CALCDEFAULT, and CALCLINE	Essbase Technical Reference
Essbase Spreadsheet Add-in for Excel	Calculating a Database	Essbase Spreadsheet Add-in for Excel Online Help

Canceling Calculations:
To stop a calculation before Essbase completes it, click the Cancel button while the calculation is running.

When you cancel a calculation, Essbase performs one of the following operations:

• Reverts all values to their previous state.
• Retains any values calculated before the cancellation.

How Essbase handles the cancellation depends on the Essbase Kernel Isolation Level settings.

Parallel and Serial Calculation:
Essbase supports parallel and serial calculations:

• Serial calculation (the default): All steps in a calculation run on a single thread. Each task is completed before the next is started.
• Parallel calculation: The Essbase calculator can analyze a calculation, and, if appropriate, assign tasks to multiple CPUs (up to 4).

Security Considerations:
To calculate a database, you must have Calculate permissions for the database outline. With calculate permissions, you can calculate any value in the database and you can calculate a value even if a security filter denies you read and update permissions. Careful consideration should be given to providing users with calculate permissions.