Hyperion Essbase Online Training

Home / Hyperion Essbase Online Training

Hyperion Essbase Online Training Course



Duration: 4 –  5 Weeks

Hyperion ESS Base Course Content

  • Overview of the Data Warehousing Concepts
  • Introduction of Data
  • Warehousing Concepts
  • Schema Models
  • OLAP Models and brief explanation on ROLAP and MOLAP
  • Identification of Dimensions and Facts
  • create the Model to build cubes based on Real Scenarios
  • Introduction to Hyperion Tools and Advantages
  • Essbase Architecture and Flow of Development
  • Life Cycle of Essbase Cubes
  • Essbase Installation and Configuration Procedure

Essbase Storage Properties 

  • Essbase Terminology and Family Tree Relationships
  • Introduction of Database Design
  • Consolidation Operators
  • 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
  • Duplicate Member Name Support

Essbase Cube Implementation from Scratch 

  • Creating Standard and Attribute Hierarchies
  • Creating Accounts Hierarchies
  • ETL Operations while Rule File Building
  • Dimensional and Data Loading using Interface tables and  Flat Files

  BSO Cube Implementation 

  • BSO Cube Implementation
  • Dense and Sparse Concept, Block Structure
  • Data Storage Properties
  • Calculation Scripts
  • HourGlass Method Importance
  • Design and Optimization Technique
  • Partitions and there types

ASO Cube Implementation

  • Aggregations
  • ASO Physical Structure
  • Table space and Restructuring
  • MDX Scripts
  • Design and Optimization

Scripts Implementation

  • Automation of Cube Loading using MaxL Scripts
  • Report Scripts

Security and Administration 

  • 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

Introduction to Excel-Addin and Smart View 

  • Accessing Cubes using Essbase Excel Adding and
  • generate Reports
  • Performing Adhoc Analysis using Smart View Tool
  • Various Options that is available in Essbase Excel- Adding and
  • Smart View Tools

  Essbase Studio Tool

  • Essbase Studio Overview
  • Adding data Sources
  • Modeling data sources -Mini schemas
  • Modeling data sources -Organizing Meta data elements
  • Modeling data sources -Dimension Elements and Hierarchies
  • Modeling data sources -Cube Schemas
  • Deployment of Cube from Essbase Studio to
  • Essbase Administration Services Console
  • Drill THROUGH Reports
  • Data Lineage