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.

Image of a calculation worksheet in an 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 the cloud service. 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

See Naming Conventions in Calculation Scripts, Report Scripts, Formulas, Filters, and Substitution and Environment Variable Values In Designing and Maintaining Essbase Cubes

The File Name defines the calculation script name. The calculation script created on the cloud service 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 on the cloud service, 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.