Calculation Commands Overview

You use Essbase calculation scripts to create calculations that differ from those defined in the database outline. Calculation scripts enable development of custom operations to supplement the built-in calculation of a block storage database outline.

Calculation commands are the elements of calculation scripts that instruct Essbase in the calculation rules to be used.

When a database is created, a default calculation script is set to "calculate all", which means that it will calculate all dimensions based on the database outline's hierarchical relationships and formulas.

You can override this default script by using a custom script. You can use the custom script(s) temporarily or permanently, without altering the default script. In the custom script, you can refer to calculation rules defined in the database outline or you can specify custom formulas, calculation formats, and calculation orders.

A calculation script contains a series of calculation commands. The order of the commands defines the execution order of the calculation.