Hyperion Essbase

Overview :

Oracle Hyperion Essbase is widely considered as the industry leading multi-dimensional online analytical processing (OLAP) server provides a rich environment for effectively developing custom analytic and enterprise performance management applications. It is the multidimensional database software that is optimized for analysis, planning, and management reporting applications. It uniquely blends an innovative technical design with an open, client-server architecture.

Training Objectives of Essbase :

Our Main Objective of Essbase course is to help administrators or developers gain knowledge of the fundamental aspects of Hyperion Essbase and enable you to quickly and effectively build efficient applications. Complete overview of the Course is ideal for project managers and administrators. This course is tailor made to focus on Essbase functionality which relates to the administration of a Hyperion Planning application.

Target Students and Prerequisites :

Students must have Knowledge on Microsoft Windows and Excel and Database Concepts

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

Courses Duration : 3-4 weeks