Hyperion Training

Hyperion ESSBASE Training teaches you all that is required to "write back" to an application's data repository under security. Oracle Essbase enables business users to quickly model complex business scenarios. Oracle Essbase enables business users to quickly model complex business scenarios.


Online training – Anytime Anywhere

Hyperion Training

Demo Date Course Duration (Hrs)  
28 Oct 2016 30
29 Oct 2016 30
30 Oct 2016 30
, Contact Us Now!    

Drop Us A Query

Hyperion is a Business Intelligence [BI] and Business Performance Management [BPM] tool for Operational and Strategic Planning. Hyperion ESSbase is a multidimensional database management system build analytic applications. Extended spreadsheet database support two storage options sparsely to minimize the amount of physical memory and disk space. The database hides the implementation from front-end tools and the full hypercube can be navigated naturally and it is possible to load values into any cell interactively. Calculation engine of ESSbase can specify calculations as the aggregation of values through dimensional hierarchies and dynamically calculated dimension members. A key strength of Oracle ESS base lies in its ability to allow users to “write back” to an application’s data repository under security. All these would be covered in Hyperion training sessions.

Hyperion Training Overview

Mindmajix’s Hyperion Essbase Training is designed to provide step-by-step instructions on how to perform a variety of tasks. Narrated presentations accompanied by task-oriented demonstration of every concept features. During this course, students gain an understanding of block storage capabilities such as Hybrid Aggregation Mode in Block Storage Database, how to maintain and optimize ESSbase database, administration services and also Learn the techniques required to create reports and perform ad hoc analysis using the Essbase Spreadsheet for budgeting, forecasting and reporting.


Hyperion Training Curriculum

curriculum_moduleData Warehousing Concepts

Starting this course with a brief over data warehousing concepts.

Introduction of Data-Warehousing Concepts
Schema Models
OLAP Models and brief explanation on ROLAP and MOLAP
Identification of Dimensions and Facts and 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

curriculum_moduleEssbase Storage Properties

This module talks about the database design and 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

curriculum_moduleEssbase Cube Implementation from Scratch

In this module, you will learn how to create account hierarchies and ETL operations.

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

curriculum_moduleBSO Cube Implementation

All about block structures are explained in this module.

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

curriculum_moduleASO Cube Implementation

All about ASO cube is explained in this module.

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


Scripts are explained in detail in this module of training.

Automation of Cube Loading using MaxL Scripts
Report Scripts

curriculum_moduleSecurity and Administration

Learn all about shared services, server and application log files and much more in this module.

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

curriculum_moduleIntroduction to Excel-Adding and Smart View

Woking with Essbase excel add-in, in this module.

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

curriculum_moduleIntroduction to Planning

Oracle Hyperion Planning

Planning Architecture

Planning Business Process

Planning Business Scenario

curriculum_moduleNavigating Planning

Interface: Overview

Launching the Simplified Interface

curriculum_moduleIntroduction to Applications and Dimensions

Planning Application: Overview

Application Framework

Planning Dimensions

Aggregate Storage Databases

Data Block Creation Process

Aggregation, Storage, and Calculation Options

curriculum_moduleCreating Planning Applications

Application Creation Process

Managing Data Sources

Creating Simple Applications

Creating Advanced Applications

Refreshing Essbase Databases

Adding Plan Types

curriculum_moduleManaging Dimensions

Building Dimension Hierarchies

Performance Settings and Data Type Evaluation Order

Accessing Dimensions Information

Managing Dimensions in the Simplified Interface

Managing Dimensions in EPM Workspace

Managing Dimensions in Smart View

curriculum_moduleSetting Up Aliases, Currencies, Years, and Periods

Creating Aliases

Adding Currencies

Customizing Time Periods

curriculum_moduleSetting Up Scenarios and Versions

Scenarios and Versions

Creating Scenarios

Creating Versions

curriculum_moduleSetting Up the Entity and Account Dimensions

Entities: Overview

Adding Entities

Deleting Entities

Accounts: Overview

Account Types and Time Balance Properties

Saved Assumptions

Data Types and Exchange Rate Types

Adding and Aggregating Accounts

curriculum_moduleLoading Metadata

Metadata Load Options

Creating Metadata Load Files

Exporting Metadata

Importing Metadata

DRM Metadata Load Process

Application Management

curriculum_moduleCreating User-Defined Elements

Creating Member Formulas

User-Defined Dimensions

Attribute Dimensions

Adding User-Defined Attributes

Smart Lists: Overview

Enabling the Simplified Interface

Customizing Interface Appearance

curriculum_moduleSetting Up Exchange Rates

Currencies and Exchange Rates

Creating Exchange Rate Tables

Currency Conversion Calculation Scripts

curriculum_moduleLoading and Calculating Data

Data Load Options

Managing Planning Data

Exporting Data

Importing Data

FDMEE Data Load Process

Data Calculations

curriculum_moduleSetting Up Planning Security

Planning Security: Overview

User and Group Provisioning in Shared Services

Specifying Advanced Settings

Assigning Access Permissions

curriculum_moduleCreating Forms

Forms: Overview

Form Components

Creating Simple Forms

Creating Composite Forms

Exporting and Importing Forms

curriculum_moduleEnhancing Forms

Creating Complex Forms

Specifying Application Settings

Specifying User Variables

Setting Individual Display Options

Creating Menus

Creating Formula Rows and Columns

Building Validation Rules

curriculum_moduleEntering Data in Planning

Navigating Forms

Submitting Data in Forms

Filtering Data

Sorting Data

Spreading Data

Adjusting Plan Data

curriculum_moduleAnnotating and Analyzing Data

Adding Annotations to Plan Data

Clearing Cell Details

Working with Ad Hoc Grids

curriculum_moduleManaging Business Rules

Business Rules: Overview

Determining Calculation Requirements

Launching Calculation Manager and Rule Components

Managing Views

Creating Business Rules and Rule Sets

Validating and Deploying Rules

Assigning Business Rule Security

Launching Business Rules

curriculum_moduleSetting Up the Approval Process

Approvals: Overview

Creating Planning Unit Hierarchies

Assigning Scenario and Version Combinations

Synchronizing Planning Unit Hierarchies

Exporting and Importing Planning Unit Hierarchies

Updating the Promotional Path with Validation Rules

curriculum_moduleManaging 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

curriculum_moduleCreating Task Lists

Task Lists: Overview

Navigating Task Lists

Task List Creation Process


A: Creating Applications in Performance Management Architect

Case Study

curriculum_moduleAbout Data Relationship Management

curriculum_moduleTask Group Descriptions

Key User Experience Differences

curriculum_moduleManaging Versions

Data Relationship Management Version Life Cycle
Version Type and Status
Creating Versions
Copying Versions
Saving Versions
Creating As-Of Versions
Editing Version Properties
Assigning Validations to Versions
Unloading and Deleting Versions

curriculum_moduleManaging Hierarchies

Creating Hierarchies
Editing Hierarchy Properties Databases
Enabling and Disabling Node Types
Opening Hierarchies
Creating Hierarchy Groups
Assigning Hierarchies to Hierarchy Groups
Assigning Controlled Properties
Assigning Controlled Node Access Groups
Assigning Validations
Deleting Hierarchies

curriculum_moduleWorking with Nodes

About Nodes and Adding and Inserting Nodes
ID Function, Modeling a Node and Moving and Ordering Nodes
Relaxed Move Option, Sorting Nodes and Node Deletion Methods
Merging Nodes, Deleting Nodes and Removing Nodes
Annulling Nodes and Inactivating Nodes
Reactivating Nodes and Assigning Validations
Orphan Nodes and Viewing Orphan Nodes
Deleting Orphan Nodes and Navigating in Tree View
Finding Nodes and Node Security
Using Shared Nodes
Shared Node Properties and Enabling Shared Nodes
Adding and Inserting Shared Nodes and Removing and Deleting Shared Nodes
Renaming Shared Nodes
Converting a Shared Node to a Primary Node
Displaying Shared Nodes

curriculum_moduleManaging Properties

Property Categories
System Properties
Stats Properties
Property Value Scope and Origin
Property Status
Editing Property Values

curriculum_moduleValidating Data

Validating Versions
Validating Hierarchies
Validating Nodes
Navigating Validation Results
Navigating Version and Hierarchy Results in List View
Navigating Node Results in List View
Navigating Node Results in Tree View
Downloading Node Results
Clearing Validation Results

curriculum_moduleUsing Queries

Query Types
Creating Queries
Navigating Query Results
Navigating in List View
Navigating in Tree View
Downloading Query Results
Managing Queries
Opening Queries
Copying Queries
Deleting Queries

curriculum_moduleComparing Hierarchies

Compare Types
Visual Compare
Structure Compare
Property Compare
Rename Compare
Creating Compares
Navigating Compare Results
Navigating in List View
Navigating in Tree View
Downloading Compare Results
Managing Compares
Opening Compares
Copying Compares
Deleting Compares

curriculum_moduleWorking with Action Scripts

Loading Action Scripts From Flat Files
Downloading Action Script Results
Required Action Script Parameters
Loading Action Scripts From a Transaction Log
Loading Action Scripts From a Node Model

curriculum_moduleWorking with Imports

Import Sections
Creating Imports
Running, Copying and Deleting Imports

curriculum_moduleWorking with Exports

Creating Exports
Creating Hierarchy Exports
Creating Hierarchy XML Exports
Creating Generation Exports
Creating Compare Exports
Creating Difference Exports
Creating Version Exports
Creating Property List Exports
Creating Property Lookup Exports
Creating Transaction Log Exports
Creating Merge Log Exports
Creating Export Books
Running, Copying, Deleting Exports and Export Books

curriculum_moduleWorking with Change Requests

curriculum_moduleAuditing Transaction and Request History

Auditing Transaction History
Data Actions in Transaction History
Administrative Actions in Transaction History
Auditing Requests

curriculum_moduleUsing the Data Relationship Management Batch Client

Securing the Batch Client
Setting up Batch Client Credentials
Running the Batch Client
Saving Versions in the Batch Client
Command Line Syntax
Configuration File Syntax
Outputs and Result Codes


curriculum_moduleFinancial Management Dimensions

Scenario Dimension

Year Dimension

Period Dimension

Entity Dimension

Value Dimension

Account Dimension

Intercompany Dimension

View Dimension

Custom Dimensions

curriculum_moduleManaging Applications

Creating Application Profiles

Entering Languages

Defining Calendars

Editing Frequencies

Editing Periods

Saving Application Profiles

Creating Applications

Opening Applications

Closing Applications

Deleting Applications

curriculum_moduleManaging Metadata

Defining Accounts

Defining Custom Members

Defining Entity Members

Defining Scenario Members

Defining Application Settings

Defining Currencies

System Generated Accounts

Creating Metadata Files of APP Format

curriculum_moduleApplication Security

Provisioning Users

Creating Security Classes

Assigning Access Control to Users

curriculum_moduleManaging Data Forms

Creating Data Forms from the Form Builder

Loading Data Forms

Extracting Data Forms

Deleting Data Forms

Entering Data

Viewing Data

Entering Cell Text

Entering Line Item Detail

Calculating Data in Data forms

curriculum_moduleUsing Data Grids on Web

Creating Data Grids

Entering/Editing Data

Viewing Data

Extracting Data Grids

Loading Data Grids

curriculum_moduleManaging Data

Working With Data Files

Loading Data

Load Method

Copying Data

curriculum_moduleConsolidating Data

Consolidation Process

Entering Currency Rates

Entering Percentage Consolidations

Calculating Data

Translating Data

Consolidation Options


Consolidate All with Data

Consolidate All

curriculum_moduleUsing Journals

About Journals

Creating Journals

Regular Journals

Auto reversing Journals

Managing Journal Templates

Standard Templates

Recurring Templates

Process Journals

curriculum_moduleManaging Inter Company Transactions

Creating Inter Company Transactions

Matching Inter Company Transactions

Assigning Reason Codes

Posting IC Transactions

curriculum_moduleUsing Smart view

Creating Adhoc Reports

Managing Function Builder

Import/Export Data forms

Creating Templates

curriculum_moduleManaging Member lists



curriculum_moduleBasics of Rules

Rule Types and Rule files

About Rules and Syntax

Objects and Functions in Rules

Assigning values to Accounts

Understanding Sample Rule Files

Loading and Extracting Rules

curriculum_moduleCreating Task lists

About Task lists

Creating Task lists

Adding Items to Task lists

Linking Task lists

Managing Task lists

curriculum_moduleManaging Process Management

Using Process Control

Promoting Process Units

Approving Process Units

Publishing Process Units

Locking/Unlocking Process Unit

curriculum_moduleHyperion Financial Reporting Basics

Creating Connection

Using Data Forms

Using Charts (Bar, Line, Pie charts)

Conditional Formatting

Creating PDF Reports

curriculum_moduleMigration and LCM

Using Copy Application Utility

Migrating Artifacts using LCM

Application to File system

File System to Application


Exam & Certification

To become expertise in Hyperion, it is mandatory to fulfill both the following criteria:

1. MindMajix Certification test verifies proven skills and fundamental knowledge in Hyperion and equip with the essential abilities to work with the tool, Interactive Reporting Web Client and EPM Workspace, Construct queries with a relational data source and generate reports using Oracle Hyperion Interactive Reporting Studio.

2. Clearing the online examination with a minimum score of 80%

The prerequisites to take this course are:

Basic knowledge of database concepts, data warehousing and JavaScript is a must and Familiarity with writing SQL queries on multiple database objects can be an added advantage.


Hyperion Course FAQs

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

The Training itself is Real-time Project Oriented.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of the leading providers of Online training, we have customers from USA, UK, Canada, Australia, UAE and other parts of the world. We are located in the USA.

Mindmajix Technologies Inc

14 Pasco Drive
East Windsor, Connecticut, 06088
United States (US)
Phone: 201 378 0518


Job Support

Mindmajix Job support’s aim is to train and support as many young IT professionals as possible in achieving their tasks for attaining quality jobs in the regular workforce.

For a fresher in IT, the actual requirement of programming and development standards could be partially or completely different in the job environment. Job support gives graduates that extra guidance before or after they attempt employment into IT sector by assisting them with the Hyperion training by highly experienced and real time professionals with full stack technical background in the Hyperion field. They address your complete issues that you face periodically.

We have wide-spread services across India, USA, Australia and other countries, assisting software employed people to excel in their jobs when they have an onset of a worsening condition.

Our trainers support you solve your technical problem and guide you to the right path in order to obtain a favourable solution. Once we understand your project, the subsequent problems are solved even better and faster.

What we assure?

* Our trainers make it a point to make you capable of understanding the real world scenarios.

* Our trainers will provide exceptional Technical assistance and help you out solve your Technical problems at your jobs in an efficient way.

* We assist the person learn a new job, and ensure extra assistance or a different format for learning the role vividly.

We Specialize in providing most reliable support and you can entirely entrust to us.

Course Reviews


1568 ratings
  • 51098
  • 4235
  • 3157
  • 263
  • 116
Course Adviser

Fill your details, course adviser will reach you.

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.