Oracle Hyperion Essbase (Detailed Curriculum)
- Module 1: Essbase Overview
- Module 2: Designing Applications and Databases
- Module 3: Designing Data Descriptor Dimensions
- Module 4: Optimizing Data Descriptor Dimensions
- Module 5: Developing Dimension Designs
- Module 6: Creating Basic Dimension Build Rules Files
- Module 7: Creating Advanced Dimension Build Rules Files
- Module 8: Loading Data
- Module 9: Getting Started with Smart View
- Module 10: Creating Reports with Smart View
- Module 11: Creating Calculation Scripts
- Module 12: Developing and Testing Complex Calculation
Module 1: Essbase Overview
- Multidimensional Analysis
- Oracle’s Enterprise Performance Management System
- Oracle BI Foundation Suite
- Essbase
- Production Environment Components
Module 2: Designing Applications and Databases
- Essbase Implementation Process
- Analyzing and Planning Implementations
- Creating Applications and Databases
- Creating Outlines
Module 3: Designing Data Descriptor Dimensions
- Data Descriptor Dimensions Overview
- Designing Time Dimensions
- Designing Scenario Dimensions
- Outline Calculations
- Designing Accounts Dimensions
- Testing Outline Calculations
Module 4: Optimizing Data Descriptor Dimensions
- Data Descriptor Dimensions Overview
- Designing Time Dimensions
- Designing Scenario Dimensions
- Outline Calculations
- Designing Accounts Dimensions
- Testing Outline Calculations
Module 5: Developing Dimension Designs
- Business View Dimensions Overview
- Attributes in Database Design
- Combining Business Views
- Developing Label Outlines
Module 6: Creating Basic Dimension Build Rules Files
- Rules Files Overview
- Creating Dimension Build Rules Files
- Configuring Dimension Maintenance Settings
Module 7: Creating Advanced Dimension Build Rules Files
- Advanced Dimension Build Rules Files Overview
- Creating Shared Members
- Manipulating Fields
- Creating User-Defined Attributes
- Creating Attribute Dimensions with Rules Files
Module 8: Loading Data
- Data Load Overview
- Creating Data Load Rules Files
- Selecting and Rejecting Records
- Capturing New Members
Module 9: Getting Started with Smart View
- Navigating Smart View
- Connecting to Data Sources
- Creating Ad Hoc Grids
- Setting the Point of View
- Associating Data Sources with Worksheets
- Creating Free-Form Grids
Module 10: Creating Reports with Smart View
- Updating Essbase Data
- Integrating Essbase Data with Microsoft Office
- Creating Shared Database Perspectives
- Creating Custom Reports
Module 11: Creating Calculation Scripts
- Calculation Script Organization
- Troubleshooting CALC DIM Processes
- Returning Correct Calculation Results
Module 12: Developing and Testing Complex Calculation Scripts
- Implementing a Script Development Process
- Upper-Level Data Loads
- Intelligent Calculation