Note: This is Base Content and may change
based on requirements.
Hyperion EssBase Contents
1.Essbase Overview
Ø Multidimensional Analysis
Ø Oracle’s Enterprise Performance Management System
Ø Essbase
Ø Production Environment Components
2.Designing Applications and
Databases
Ø Creating Applications and Databases
Ø Creating Outlines
3.Designing Data Descriptor
Dimensions
Ø Data Descriptor Dimensions Overview
Ø Designing Time Dimensions
Ø Designing Scenario Dimensions
Ø Outline Calculations
Ø Designing Accounts Dimensions
Ø Testing Outline Calculations
4.Optimizing Data Descriptor
Dimensions
Ø Creating Member Aliases
Ø Dimension Types
Ø Creating Period-to-Date Totals
Ø Dynamic Calc Members
Ø Enhancing Accounts Dimensions
Ø Optimizing Data Storage
5.Developing Dimension Designs
Ø Business View Dimensions Overview
Ø Attributes in Database Design
Ø Combining Business Views
Ø Developing Label Outlines
6.Creating Basic Dimension Build
Rules Files
Ø Rules Files Overview
Ø Creating Dimension Build Rules Files
Ø Configuring Dimension Maintenance Settings
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
8. Loading Data
Ø Data Load Overview
Ø Creating Data Load Rules Files
Ø Selecting and Rejecting Records
Ø Capturing New Members
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
10.Creating Reports with Smart
View
Ø Updating Essbase Data
Ø Integrating Essbase Data with Microsoft Office
Ø Creating Shared Database Perspectives
The course is yet to be scheduled