Starting this course with a brief over data warehousing concepts.
Introduction of Data-Warehousing Concepts
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
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
Design and Optimization
Scripts are explained in detail in this module of training.
Automation of Cube Loading using MaxL 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
Have any queries regarding course curriculum, speak to our course advisorConnect with Advisor
Upon completion of our training, you will be able to:
This course will benefit the following job roles:
After completing our training, the student will be able to:
Upon successful completion of the program, you will be awarded a Certificate from Mindmajix for Hyperion Training.
Successfully complete your course and let the community know about your achievement.
Get your Course Completion certificate from Mindmajix.
Don’t just show off your achievement to the community, use it to advance in your career.
The cost of the Hyperion Certification exam is 245 USD.
Work on real time Hyperion projects - The primary goal of this project work is to to gear up the skill set required and amplify individual competencies, experience, exposure which align with the current job market to addresses real world business challenges.
Have questions? We’ve got the answers. Get the details on how you can grow in this course.
Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.
Yes, we will discuss with our instructor and will schedule according to the time convenient to you.
The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.
The trainer is a certified consultant and has significant amount of experience in working with the technology.
We will take care of providing you with all that is required to get placed in a reputed MNC and also forward your resume to the companies we tie-up with. Starting from providing the in-depth course material to explanation of the real-time scenarios and preparing your resumes, we will make you gain expertise so that you can get a job.
We assist you completely in acquiring certification. We ensure you will get certified easily after our training.
Yes, we accept payments in two installments.
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 first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.
Our trainer explains every topic along with real-time scenarios. In the last one or two sessions, the trainer will explain one end-to-end project to showcase the real time working environment.
Have More Questions. Reach our Support TeamContact us
The major career paths available for Hyperion professionals are listed below:
Have any queries regarding Hyperion course, speak to our course advisorTalk to Course Advisor
See if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Mindmajix
Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in Hyperion
By providing us with your details, We wont spam your inbox.