You are here: Training Hyperion Essbase & Planning

Hyperion is a Business Intelligence (BI) and Business Performance Management (BPM ) Tool. Its the market leader in Financial, Operational and Strategic Planning. It has applications for Planning, consolidation, scorecarding, reporting, dashboards, Analysis, Workspace, Master Data Management and Foundation. There is a sufficient demand in the industry for essbase consultants. ADIVA CONSULTING is equipped with well trained human resources, Real-time Corporate Trainers, modern infrastructure - hardware and software resources.

Hyperion Essbase and Planning Training:

Adiva consulting, is a Expertise in Business Intelligence and Fusion Middleware Solutions,The online training model enables international participants to receive Hyperion Training without leaving their desks. Adiva Consulting offers training in HYPERION & other related concepts along with Real Time Instructor Led Live Online Training.

Please contact  This e-mail address is being protected from spambots. You need JavaScript enabled to view it  for details

About Instructor :- Trainer is working in Financial Company having 6+ years of experience in Hyperion Essbase and Hyperion Planninghaving a good command on subject area and good communication skills. 


· Real Time Instructor Led Live HYPERION Training 

· Customized Courses matching the job requirements of the consultant

· Convenience of learning anytime/anyplace

· Training with Live Examples

· Training Material Support PPT's & Pdf Docs

· Practicals after every major topic

· Software access for practice

· Round the Clock Support

· Feedback from training coordinators throughout the course

· All at reasonable Price · 

Hyperion Essbase & Planning Course Contents:


Part 1: Data Warehousing Concepts

1.     Introduction of Data-Warehousing Concepts

2.     Schema Models

3.     OLAP Models and brief explanation on ROLAP and MOLAP

4.     Identification of Dimensions and Facts and create the Model to build cubes based on Real-Scenarios

5.     Introduction to Hyperion Tools and Advantages

6.     Essbase Architecture and Flow of Development Life Cycle of Essbase Cubes

7.     Essbase Installation and Configuration Procedure

Part 2: Essbase Storage Properties

1.     Essbase Terminology and Family Tree Relationships

2.     Introduction of Database Design

3.     Data Storage Properties

4.     Time Balance and Expense Reporting Properties

5.     UDAS, Attribute and Alternate Hierarchies

6.     Introduction to ASO and BSO Options

7.     Creating Essbase Applications and Databases

8.     Understanding the Time, Scenario and Measures Dimension Concepts

9.     Creating and building the dimensions rule files using Essbase Administration Services Console

10.   Loading the data in Different Methods

11.   Consolidation Operators

12.   Duplicate Member Name Support

Part 3: Essbase Cube Implementation from Scratch

1.     Creating Standard and Attribute Hierarchies

2.     Creating Accounts Hierarchies

3.     ETL Operations while Rule File Building

4.     Dimensional and Data Loading using Interface tables and Flat Files

Part 4: BSO Cube Implementation

1.     Dense and Sparse Concept, Block Structure

2.     Data Storage Properties

3.     Calculation Scripts

4.     Hour-Glass Method Importance

5.     Design and  Optimization Technique

6.     Partitions and there types

Part 5: ASO Cube Implementation

1.     Aggregations

2.     ASO Physical Structure

3.     Table space and Restructuring

4.     MDX Scripts

5.     Design and Optimization

Part 6: Scripts

1.     MDX Basic

2.     Automation of Cube Loading using MaxL Scripts

3.     Report Scripts

 Part 7: Security and Administration

1.     Introduction to Shared Services Console

2.     Creating Users and Groups

3.     Assign Cube and Filter Access to Groups

4.     About Essbase Services

5.     Essbase Config, Server and Application Log Files

6.     Locks and Sessions

7.     Backup and Recovery Methods

8.     Introduction to Life Cycle Management

Part 8: Introduction to Excel-Addin and Smart View

1.     Accessing Cubes using Essbase Excel-Addin and generate Reports

2.     Performing Adhoc Analysis using Smart View Tool

3.     Various Options that is available in Essbase Excel-Addin and Smart-View Tools

Hyperion Planning

Part 1: Introduction to Hyperion Reporting

1.     Introduction to Planning Tool

2.     Applications and Plan Types Defined

3.     Planning Dimensions

4.     Advantages of Planning tool

5.     Planning Architecture

Part 2: Workspace and Planning Application

1.     Introduction and Navigating to Workspace

2.     Introduction to Planning Web Client in End User Perspective

3.     Creating Classic Planning Application

4.     Creating Inbuilt and user-defined Dimensions

5.     Introduction to Outline Load Utility

6.     Loading Metadata to Planning Application from Flat files using Outline Load Utility

7.     Deploying Planning Application to EAS Console

8.     Loading Fact Data using Rule Files in EAS Console

Part 3: Creating Business Rules

1.     Business Rules Overview

2.     Calculation Manager Overview

3.     Business Rules Creation Process

4.     Calculation Manager Security

5.     Setting Up Business Rules

6.     Validating, Deploying, and Launching Business Rules

7.     Creating Variables and Runtime Prompt Variables

8.     Creating Formulas

9.     Adding Conditional Statements

10.   Creating Member Ranges

11.   Designing Scripts

Part 4: Data Forms

1.     Data Forms Introduction

2.     Create a Data Form

3.     Create a Composite Data Form

4.     Manage the Data Form

5.     Custom Menus

6.     Assigning Menu to a Data Form

Part 5: Manage Security

1.     Create a Native Group and User

2.     User Authentication and Authorization for Planning Applications

3.     Refresh Security to Essbase

4.     Assigning Provisioning to Groups

Part 6: Task Lists

1.     Creation of Task Lists with Real-Time Scenarios

2.     Assigning BR’s to Task Lists

3.     Usage of Task Lists

4.     Report Generation

1 comment

Leave a comment

Make sure you enter the (*) required information where indicated.
Basic HTML code is allowed.