Hyperion Essbase & Planning Training

(3) 3 Ratings

Course Schedule



Mon - Sat

07:30 PM - 10:00 PM ( IST )



Mon - Fri

11:00 AM - 02:00 PM ( IST )



Sat - Sun

05:30 AM - 06:30 AM ( IST )

Total Learners

725 Learners

LMS Access

365 days

Course duration

30 days


24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

Introduction To Planning

  • Oracle Hyperion Planning
  • Planning Architecture
  • Planning Business Process
  • Planning Business Scenario. 

Navigating Planning

  • Interface: Overview
  • Launching the Simplified Interface 

Introduction To Applications And Dimensions

  • Planning Application: Overview
  • Application Framework
  • Planning Dimensions
  • Aggregate Storage Databases
  • Data Block Creation Process
  • Aggregation, Storage, and Calculation Options.

Data Warehousing Concepts

  • Identification of Dimensions and Facts. 
  • Create the Model to build cubes based on Real-Scenarios
  • Introduction to Hyperion tools and Advantages 
  • Essbase Architecture and 
  • The flow of the Development Life Cycle of Essbase Cubes.
  • Essbase Installation and Configuration Procedure. 

Essbase Storage Properties

  • Essbase Terminology and Family Tree Relationships
  • Introduction of Database Design
  • Data Storage Properties
  • Time Balance and Expense Reporting Properties
  • UDAS and Attribute and Alternate Hierarchies
  • Introduction to ASO and BSO Options
  • Creating Essbase Applications and Databases
  • Understanding the Time, Scenario and Measures Dimension Concepts
  • Creating and building the dimensions rule files using Essbase Administration Services Console.
  • Loading the Data in Different Methods
  • Consolidation Operators and Duplicate Member Name Support. 

Managing Fragmentation

  • Measuring Database Fragmentation
  • Preventing and Reducing Database Fragmentation
  • Removing Security File Fragmentation.

BSO Cube Implementation

  • Dense and Sparse Concept
  • Block Structure
  • Data Storage Properties
  • Calculation Scripts Hour-Glass Method Importance Design and Optimization Technique
  • Partitions and their types. 

Security And Administration In Hyperion Essbase Training

  • Introduction to Shared Services Console
  • Creating Users and Groups
  • Assign Cube and Filter Access to Groups
  • Essbase Config Server and Application Log Files
  • Locks and Sessions
  • Backup and Recovery Methods
  • Introduction to Life Cycle Management and Usage. 

Managing The Approval Process

  • Approvals Dashboard
  • Planning Unit Approval States
  • Reviewer Actions
  • Impact of Entity Hierarchy on the Review Process
  • Managing the Review Cycle
  • Viewing and Resolving Validation Errors
  • Copying Data Between Versions
  • Copying Data. 

Creating Task Lists

  • Task Lists: Overview
  • Navigating Task Lists
  • Task List Creation Process 

Course Description

What are the objectives and learning outcomes of this course?

  • Oracle Hyperion Planning
  • Navigating Planning
  • Introduction to Applications and Dimensions
  • Setting Up Aliases, Currencies, Years, and Periods
  • Creating User-Defined Elements
  • Loading and Calculating Data
  • Setting Up and Managing the Approval Process.

Who Should Attend this Training?

  • Business Developers 
  • Technical consultants
  • Data and Report Analysts
  • Financial Professionals
  • Database and BI Professionals
  • Aspirants aiming for a career in the prospective field. 

What Are The Pre-Requisties For This Training?

  • Functional knowledge of standard Enterprise Performance Management,
  • Introduction to planning and Essbase,
  • The basic idea about loading data requirements is an added advantage.


Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews


It was a great experience to undergo and get certified in the Hyperion planning Course from LTB. As a working professional, it has not only given me an exposure to the domain but also helped me learn cross technologies and develop an inclination towards it. Thank you.


Had a Great Experience in learning the Course with LTB. The trainer has a Practical Knowledge about the subject and taught us with real-time scenarios. Thank you LTB.


Hi myself Abhinav, I really impressed with the experience in LTB. Our trainer is one of the best I have ever seen. He taught each and every concept in a detailed manner. Thank you so much.