Part VI: Calculating Data
This part describes how to calculate the data in OLAP Server databases, including how to create formulas, define the calculation order, calculate data values dynamically, calculate time series data, and create calculation scripts:
- Introduction to Database Calculations, explains the basic concepts behind database calculations.
- Developing Formulas, explains 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 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 Calculation Scripts, introduces you to calculation scripts and describes how to create calculation scripts using the Calc Script Editor.
- Examples of Calculation Scripts, contains detailed examples of calculation scripts.
Note: For optimization information, see Optimizing Calculations, and Optimizing with Intelligent Calculation.