24 Develop Calculation Scripts for Block Storage Cubes

You can write Essbase calculation scripts to perform calculations other than those defined by the cube outline. You can clear and copy data, fix on subsets of data, implement variables, control flow, regulate block creation, and more. Calculation scripts can contain commands, equations, and formulas.

• Calculate a Cube with Calculation Scripts

• Learn Basic Calculation Script Syntax

• Use Calculation Commands

• Formulas in Calculation Scripts

• Substitution Variables in Calculation Scripts

• Runtime Substitution Variables in Calculation Scripts Run in Essbase

• Runtime Substitution Variables in Calculation Scripts Run in Smart View

• Clear and Copy Data

• Calculate a Subset of Data in the Cube

• Enable Calculations on Potential Blocks

• Use Calculation Scripts on Partitions

• Save, Execute, and Copy Calculation Scripts

• Check Calculation Results

The information in this chapter applies only to block storage cubes, and is not relevant to aggregate storage cubes.