Part V

Calculating Data

Part V describes how to calculate the data in Hyperion Essbase OLAP Server databases, including how to create formulas, define the order in which Hyperion Essbase calculates dimensions and members, calculate data values dynamically, calculate time series data, create calculation scripts, and optimize calculations. Part V contains the following chapters:

Introduction to Database Calculations introduces you to the basic concepts behind database calculations.
Developing Formulas introduces you to formulas and describes how to create formulas on members using the Formula Editor.
Examples of Formulas contains detailed examples of formulas.
Defining the Calculation Order describes how to set the calculation order of the members in a database.
Dynamically Calculating Data Values describes how to set Hyperion Essbase to calculate the values for dimensions and members when they are requested by users, instead of in advance.
Calculating Time Series Data describes how to calculate time series data including First, Last, Average, and Period-To-Date values for both single server and partitioned applications.
Developing Calc Scripts introduces you to calc scripts and describes how to create calc scripts using the Calc Script Editor.
Examples of Calc Scripts contains detailed examples of calc scripts.
Developing Custom-Defined Calculation Macros introduces you to calculation macros and how to create them.
Developing Custom-Defined Calculation Functions describes how to create custom calculation function and use them in calculations.
Optimizing Calculations describes how to make your calc scripts execute more quickly.
Using Intelligent Calculation to Optimize Calculation describes how to use intelligent calculation to make your calc scripts execute more quickly.