Using Calculation Scripts

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:

The following calculation script calculates the Actual values from the Year, Measures, Market, and Product dimensions:

FIX (Actual)
   CALC DIM(Year, Measures, Market, Product);
ENDFIX

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.