A calculation script, which contains a series of calculation commands, equations, and formulas, allows you to define calculations other than those defined by the database outline.
In a calculation script, you can perform a default calculation (CALC ALL) or a calculation of your choosing (for example, you can calculate part of a database or copy data values between members).
You must write a calculation script to perform any of the following tasks:
Change the calculation order of the dense and sparse dimensions in a database
Perform a complex calculation in a specific order or perform a calculation that requires multiple iterations through the data (for example, some two-pass calculations require a calculation script)
Perform any two-pass calculation on a dimension without an accounts tag
See Designing and Building Currency Conversion Applications.
Calculate member formulas that differ from formulas in the database outline (formulas in a calculation script override formulas in the database outline)
Use an API interface to create a custom calculation dynamically
Use control of flow logic in a calculation (for example, to use the IF…ELSE…ENDIF or the LOOP…ENDLOOP commands)
Clear or copy data from specific members
See Copying Data.
Define temporary variables for use in a database calculation
Force a recalculation of data blocks after you have changed a formula or an accounts property on the database outline
Control how Essbase uses Intelligent Calculation when calculating a database
The following calculation script calculates the Actual values from the Year, Measures, Market, and Product dimensions:
Using Calculation Script Editor in Administration Services Console, you can create calculation scripts by:
See “About Calculation Script Editor” in the Oracle Essbase Administration Services Online Help.
Calculation scripts created using Administration Services are given a .csc extension by default. If you run a calculation script from Administration Services, Smart View, or Spreadsheet Add-in, the file must have a .csc extension. However, because a calculation script is a text file, you can use MaxL or ESSCMD to run any text file as a calculation script.
A calculation script can also be a string defined in memory and accessed through the API on an Essbase client or an Essbase Server. Therefore, from dialog boxes, you can dynamically create a calculation script that is based on user selections.