Hyperion EssBase

1 Courses 2 Projects 18 Hours

Overview

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

Curriculum

Download Curriculum

Data Warehousing Concepts

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 Storage Properties

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

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

Dense and Sparse Concept, Block Structure
Data Storage Properties
Calculation Scripts
Hour-Glass 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

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-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

Certification

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.