HYPERION ESSBASE Course Content

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