You use 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 the database outline.
Calculation commands are the elements of calculation scripts that instruct Essbase in the calculation rules to be used. You create calculation scripts using the Calculation Script Editor. Within the Calculation Script Editor, a dialog box is available that allows you to paste functions while you develop formulas. For more information, see the Oracle Essbase Administration Services Online Help.
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.