Hyperion Training

HYPERION ONLINE TRAINING

HYPERION ESSBASE COURSE CONTENT

ESSBASE OVERVIEW

  • Multidimensional Analysis
  • Oracle’s Enterprise Performance Management System
  • Essbase
  • Production Environment Components

DESIGNING APPLICATIONS AND DATABASES

  • Creating Applications and Databases
  • Creating Outlines

DESIGNING DATA DESCRIPTOR DIMENSIONS

  • Data Descriptor Dimensions Overview
  • Designing Time Dimensions
  • Designing Scenario Dimensions
  • Outline Calculations
  • Designing Accounts Dimensions
  • Testing Outline Calculations

OPTIMIZING DATA DESCRIPTOR DIMENSIONS

  • Creating Member Aliases
  • Dimension Types
  • Creating Period-to-Date Totals
  • Dynamic Calc Members
  • Enhancing Accounts Dimensions
  • Optimizing Data Storage

DEVELOPING DIMENSION DESIGNS

  • Business View Dimensions Overview
  • Attributes in Database Design
  • Combining Business Views
  • Developing Label Outlines

CREATING BASIC DIMENSION BUILD RULES FILES

  • Rules Files Overview
  • Creating Dimension Build Rules Files
  • Configuring Dimension Maintenance Settings

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

LOADING DATA

  • Data Load Overview
  • Creating Data Load Rules Files
  • Selecting and Rejecting Records
  • Capturing New Members

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

CREATING REPORTS WITH SMART VIEW

  • Updating Essbase Data
  • Integrating Essbase Data with Microsoft Office
  • Creating Shared Database Perspectives