For individuals

Recorded Video Learning

  • Access to high quality Videos
  • Self-paced learning content designed by Experts

Instructor Led Live Online Training

  • Live Interactive training
  • Certified & industry expert Trainers
  • On Demand Dedicated Cloud lab access
  • 24x7 Support & Assistance
  • Fast-track / Regular / Weekend

  • Start training at your convenient time
  • For business

    Corporate training

    • Self-paced e-learning and/or instructor-led options)
    • Course, category, and all-access pricing
    • Enterprise-class learning management system (LMS)
    • Enhanced reporting for individuals and teams
    • 24x7 assistance and support



    Course Details

    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

    ESSBASE Course Content

    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

    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

    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

    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

    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

    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

    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

    Planning Course Content

    Oracle Hyperion Planning
    Planning Architecture
    Planning Business Process
    Planning Business Scenario

    Interface: Overview
    Launching the Simplified Interface

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

    Application Creation Process
    Managing Data Sources
    Creating Simple Applications
    Creating Advanced Applications
    Refreshing Essbase Databases
    Adding Plan Types

    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

    Creating Aliases
    Adding Currencies
    Customizing Time Periods

    Scenarios and Versions
    Creating Scenarios
    Creating Versions

    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

    Metadata Load Options
    Creating Metadata Load Files
    Exporting Metadata
    Importing Metadata
    DRM Metadata Load Process
    Application Management

    Creating Member Formulas
    User-Defined Dimensions
    Attribute Dimensions
    Adding User-Defined Attributes
    Smart Lists: Overview
    Enabling the Simplified Interface
    Customizing Interface Appearance

    Currencies and Exchange Rates
    Creating Exchange Rate Tables
    Currency Conversion Calculation Scripts

    Data Load Options
    Managing Planning Data
    Exporting Data
    Importing Data
    FDMEE Data Load Process
    Data Calculations

    Planning Security: Overview
    User and Group Provisioning in Shared Services
    Specifying Advanced Settings
    Assigning Access Permissions

    Forms: Overview
    Form Components
    Creating Simple Forms
    Creating Composite Forms
    Exporting and Importing Forms

    Creating Complex Forms
    Specifying Application Settings
    Specifying User Variables
    Setting Individual Display Options
    Creating Menus
    Creating Formula Rows and Columns
    Building Validation Rules

    Navigating Forms
    Submitting Data in Forms
    Filtering Data
    Sorting Data
    Spreading Data
    Adjusting Plan Data

    Adding Annotations to Plan Data
    Clearing Cell Details
    Working with Ad Hoc Grids

    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

    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

    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

    Task Lists: Overview
    Navigating Task Lists
    Task List Creation Process

    A: Creating Applications in Performance Management Architect
    Case Study

    Hyperion DRM Course Content

    Key User Experience Differences

    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

    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

    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

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

    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

    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

    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

    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

    Import Sections
    Creating Imports
    Running, Copying and Deleting Imports

    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

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

    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

    Hyperion Financial Management Course content

    Scenario Dimension
    Year Dimension
    Period Dimension
    Entity Dimension
    Value Dimension
    Account Dimension
    Intercompany Dimension
    View Dimension
    Custom Dimensions

    Creating Application Profiles
    Entering Languages
    Defining Calendars
    Editing Frequencies
    Editing Periods
    Saving Application Profiles
    Creating Applications
    Opening Applications
    Closing Applications
    Deleting Applications

    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

    Provisioning Users
    Creating Security Classes
    Assigning Access Control to Users

    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

    Creating Data Grids
    Entering/Editing Data
    Viewing Data
    Extracting Data Grids
    Loading Data Grids

    Working With Data Files
    Loading Data
    Load Method
    Copying Data

    Consolidation Process
    Entering Currency Rates
    Entering Percentage Consolidations
    Calculating Data
    Translating Data
    Consolidation Options
    Consolidate All with Data
    Consolidate All

    About Journals
    Creating Journals
    Regular Journals
    Auto reversing Journals
    Managing Journal Templates
    Standard Templates
    Recurring Templates
    Process Journals

    Creating Inter Company Transactions
    Matching Inter Company Transactions
    Assigning Reason Codes
    Posting IC Transactions

    Creating Adhoc Reports
    Managing Function Builder
    Import/Export Data forms
    Creating Templates


    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

    About Task lists
    Creating Task lists
    Adding Items to Task lists
    Linking Task lists
    Managing Task lists

    Using Process Control
    Promoting Process Units
    Approving Process Units
    Publishing Process Units
    Locking/Unlocking Process Unit

    Creating Connection
    Using Data Forms
    Using Charts (Bar, Line, Pie charts)
    Conditional Formatting
    Creating PDF Reports

    Using Copy Application Utility
    Migrating Artifacts using LCM
    Application to File system
    File System to Application


    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, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

    Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad,  San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth etc…


    Exam Certification

    How to get certified in Hyperion?

    The information regarding Hyperion certification (Oracle Essbase 11 Certified Implementation Specialist) is available here. For passing this test, an in-depth understanding of all the Hyperion concepts is recommended. The learning path and the project Mindmajix comes up with will be exactly in line with the certification program which enables you to clear Hyperion certification exam with greater ease and secure a job in top multinationals.

    Learning Resources

    Hyperion Tutorial

    An in-depth knowledge on Hyperion Essbase project which focuses on all the critical components of Hyperion Essbase will be provided by our trainer. As a result, you can increase your visibility and increase your efficiency and draw real connections between different components of Hyperion Essbase. You will also get the complete material covering all the aspects of this project.

    Hyperion Tutorial .

    Course Reviews


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

    Drop Us A Query

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

    Fill your details, course adviser will reach you.