Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3)
Uplatz provides this comprehensive training on Oracle Essbase 11.1.2 specifically focusing on the Block Storage Databases structure.
-----------------------------------------------------------------------------------------------------------------
Course Objective
- Gain an understanding of the mechanisms by which Essbase stores and calculates data in block storage databases.
- Learn the default database calculation order and investigate how it relates to block storage data structures.
- Learn practical methods for developing and testing block storage calculations, from the simple to the complex.
- Understand where use of dynamic calculation can improve database and calculation performance.
- Focus calculations on specific subsets of data.
- Compare the different calculation variables available and implement variables in calculation scripts
- Investigate different methods for implementing and planning multidimensional allocations.
Target Audience
- Administrator
- Analyst
- Architect
- Database Administrator
- Developer
- Implementer
-----------------------------------------------------------------------------------------------------------------
Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3)
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
8. Developing Analytic Calculations
· Typed Measures Overview
· Creating Typed Measures
· Calculating with Typed Measures
9. Multidimensional Dynamic Calculations
· Dynamic Calculation Order
· Optimization Guidelines
10. Normalizing Data
· Loading Data to Upper-Level Members
· Planning Data Normalization
· Normalizing Rates and Drivers
11. Performing Advanced Allocations
· Allocating Data
· Creating Multiple-Database Calculations
12. Appendix: Essbase Architecture
· Essbase Architecture Overview
· Essbase Components by Tier
------------------------------------------------------