This Oracle Essbase 11.1.2 Bootcamp training will teach you how to develop Essbase 11.1.2 block storage databases. This specialized course gives you a firm foundation in basic database planning and development to expand your skill set.
Objectives
- Create block storage databases
- Create dimensions using rules files
- Load data using rules files
- Analyze data with Smart View
- Describe multidimensional calculation
- Create basic database calculations
- Analyze dimension attributes
- Analyze non-numeric data
Topics
- Introduction to Essbase
- Designing Applications and Databases
- Designing Data Descriptor Dimensions
- Optimizing Data Descriptor Dimensions
- Developing Dimension Designs
- Creating Basic Dimension Build Rules Files
- Creating Advanced Dimension Build Rules Files
- Loading Data
- Getting Started with Smart View
- Creating Reports with Smart View
- Case Study: Country Kitchen Desserts
- Data Storage and Calculation
- Creating Calculation Scripts
- Controlling the Calculation Process
- Referencing Members in Calculations
- Developing and Testing Complex Calculation Scripts
- Normalizing Data
- Creating Attribute Dimensions
- Analyzing Varying Attributes
- Analyzing Text and Dates
Other Trainings
Middleware
43 Training Set
