Hyperion EssBase

1 Courses 2 Projects 18 Hours


Hyperion Essbase is a multidimensional database management system build  financial custom analytic reports. Hyperion Essbase Training gives insights about Data-Warehousing Concepts,creation,implementation,scripting and deploying the BlockStorage Databases.

Learn how to use Hyperion Essbase from beginner level to advanced techniques which is taught by experts.

Course Fee

Can’t find a batch you were looking for?

Let us know

Key Features

  • Flexible Schedule
  • 24 x 7 Lifetime Support
  • Certification
  • Instructor Led Training


Download Curriculum

  • Introduction of Data-Warehousing Concepts 
  • OLAP Models and brief explanation on ROLAP and MOLAP 
  • Introduction to Hyperion Tools and Advantages 
  • Essbase Architecture and Flow of Development Life Cycle of Essbase Cubes
  • Essbase Terminology and Family Tree Relationships 
  • Introduction of Database Design 
  • Data Storage Properties 
  • Time Balance and Expense Reporting Properties 
  • UDAS, 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 
  • Duplicate Member Name Support 
  • Creating Standard and Attribute Hierarchies 
  • Creating Accounts Hierarchies 
  • ETL Operations while Rule File Building 
  • Dimensional and Data Loading using Interface tables and Flat Files 
  • Dense and Sparse Concept, Block Structure 
  • Data Storage Properties 
  • Calculation Scripts 
  • Hour-Glass Method Importance 
  • Design and Optimization Technique 
  • Partitions and there types 
  • Aggregations 
  • ASO Physical Structure 
  • Table space and Restructuring 
  • MDX Scripts 
  • Design and Optimization 
  • Automation of Cube Loading using MaxL Scripts 
  • Report Scripts
  • 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
  • Accessing Cubes using Essbase Excel-Addin and generate Reports
  • Performing Adhoc Analysis using Smart View Tool 
  • Various Options that is available in Essbase Excel-Addin and Smart-View Tools

Need customized curriculum?

Talk to Us


Hyperion EssBase Certification

SLearn certification is awarded, after successful completion of the project work which shows that trainee have learned, achieved skills and experiences from the project. All the acknowledged trainees are therefore eligible for challenging projects and better job opportunities in MNC's like TCS, IBM, Cisco, Cognizant, Wipro, Dell etc.

Get Sample Certificate


Free Career Counselling

We are happy to help you