Understand Calculation Worksheets

You can have one or more calculation worksheets in an application workbook.

The following image shows a calculation worksheet in a sample application workbook.

Within the calculation worksheet, the calculation script begins in cell C6.

The name of each calculation worksheet is Calc.scriptname, for example, for the sample CalcAll calculation script, the calculation worksheet is called Calc.calcall.

The contents of the calculation worksheet are used to create a calculation script in Essbase. The calculation script uses the file name specified in the definitions area of the calculation sheet and a has a .csc extension. For example, filename.csc.

You can execute the calculation script when you build the cube in Cube Designer, if you select Run Calculation Sheets Contained within Workbook in the Build Cube dialog box. If you do not want to execute the calculation, do not select this option.

The calculation scripts are executed in the order they appear in the application workbook.

Property or Field	Valid Values	Description
File Name	A valid calculation script file name. filename.csc.	The File Name defines the calculation script name. The calculation script created in Essbase when the cube is created is the File Name with a .csc extension.
Execute Calc	Yes No	If you enter Yes, then the calculation is executed at the time you build the cube. If you enter No, then the calculation is not executed right away. In either case, each calculation worksheet creates a calculation script in Essbase, using the specified file name with a .csc extension. That way, any of the calculations can be executed at a later time.

You can modify calculation worksheets in the Designer Panel. See Work with Calculation Worksheets in Cube Designer.