Hyperion Essbase

  • Overview
  • Course Content
  • Drop us a Query

This course teaches you the principal techniques and theories to design Essbase block storage databases. Block storage databases are deployed independently for budgeting, forecasting and planning, and as the underlying data storage and analytic engine for Hyperion Planning applications.

Oracle Hyperion Essbase (Detailed Curriculum)

Module 1: Essbase Overview

Lessons

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

Module 2: Designing Applications and Databases

Lessons

  • Essbase Implementation Process
  • Analyzing and Planning Implementations
  • Creating Applications and Databases
  • Creating Outlines

Module 3: Designing Data Descriptor Dimensions

Lessons

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

Module 4: Optimizing Data Descriptor Dimensions

Lessons

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

Module 5: Developing Dimension Designs

Lessons

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

Module 6: Creating Basic Dimension Build Rules Files

Lessons

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

Module 7: Creating Advanced Dimension Build Rules Files

Lessons

  • 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

Lessons

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

Module 9: Getting Started with Smart View

Lessons

  • 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

Lessons

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

Module 11: Creating Calculation Scripts

Lessons

  • Calculation Script Organization
  • Troubleshooting CALC DIM Processes
  • Returning Correct Calculation Results

Module 12: Developing and Testing Complex Calculation Scripts

Lessons

  • Implementing a Script Development Process
  • Upper-Level Data Loads
  • Intelligent Calculation

A Few Things You'll Love!

Students Speak