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

  • 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

Partners

A Few Things You'll Love!

What our Students Speak

+
1
×
Hello

How can help you?