- 1. Essbase Overview
- 2. Data Storage and Calculation
- 3. Calculation Script Basics
- 4. Dynamic Calculation Overview
- 5. Controlling the Calculation Process
- 6. Copying and Clearing Data
- 7. Developing Advanced Calculations
- 8. Developing Analytic Calculations
- 9. Multidimensional Dynamic Calculations
- 10. Normalizing Data
- 11. Performing Advanced Allocations
- 12. Appendix: Essbase Architecture
1. Essbase Overview
- Essbase
- Essbase Database Types
- Business Scenario and Training Environment Overview
- Block Storage Calculation Overview
2. Data Storage and Calculation
- Data Storage and Calculation Fundamentals
- Database Statistics
- Data Block Creation
- Database Calculation Process
3. Calculation Script Basics
- Calculation Script Organization
- Implementing a Script Development Process
- Intelligent Calculation
4. Dynamic Calculation Overview
- About Dynamic Calculation
- Dynamic Calculation Storage Options
- Design Considerations for Dynamic Calculation
- Design Considerations for Rates and Percentages
5. Controlling the Calculation Process
- Controlling Top-Down Calculation
- Performance Considerations
- Creating Complex Conditionals
6. Copying and Clearing Data
- Copying Data
- Clearing Data with CLEARDATA
- Clearing Data with CLEARBLOCK
7. Developing Advanced Calculations
- Creating Calculation Variables
- Referencing Members Dynamically
1. Developing Analytic Calculations
- Typed Measures Overview
- Creating Typed Measures
- Calculating with Typed Measures
8. Multidimensional Dynamic Calculations
- Dynamic Calculation Order
- Optimization Guidelines
9. Normalizing Data
- Loading Data to Upper-Level Members
- Planning Data Normalization
- Normalizing Rates and Drivers
10. Performing Advanced Allocations
- Allocating Data
- Creating Multiple-Database Calculations
11. Appendix: Essbase Architecture
- Essbase Architecture Overview
- Essbase Components by Tier