24 Developing Calculation Scripts for Block Storage Databases

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

• Using Calculation Scripts

• Understanding Calculation Script Syntax

• Using Calculation Commands

• Formulas in Calculation Scripts

• Calculation Script Formulas and Intelligent Calculation Status

• Grouping Formulas and Calculations

• Using Substitution, Runtime Substitution, and Environment Variables in Calculation Scripts

• Clearing and Copying Data

• Calculating a Subset of a Database

• Enabling Calculations on Potential Blocks

• Using Calculation Scripts on Partitions

• Saving, Executing, and Copying Calculation Scripts

• Checking Calculation Results

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