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