Programming Skills

Hyperion Essbase Training

Essbase stands for Extended Spread Sheet databASE. Essbase is a multidimensional database management system (MDBMS). It provides a multidimensional database platform to build analytic applications.

Hyperion Essbase online training

trains you on Oracle Essbase, an OLAP (Online Analytical Processing) Server that provides an environment for deploying pre-packaged applications or developing custom analytic and enterprise performance management applications. The industry-leading multi-dimensional online analytical processing (OLAP) server, designed to help business users forecast likely business performance levels and deliver "what-if" analyses for varying conditions.

  • Course Overview
  • Target Audience
  • Why choose us
  • Trainer Profile
  • Understanding Multidimensional Databases Installation & Configuration, Essbase administration Services, Shared Services, Hyperion Provider server, Hyperion Essbase Server, Smart view.
  • Designing Multidimensional Application & Database
  • Building Dimensions
  • Dynamic Dimension Build & Data Load
  • Data Retrieving and Calculation
  • Calculatating Data & Security assignment

Understanding Multidimensional Databases

  • Introduction to MDDB/OLAP concepts
  • Introduction to Essbase
  • Essbase Architecture
  • Introduction to System 9
  • Difference MOLAP/ RDBM
  • Installation and Configuration on Windows

LAB: Installation & Configuration, Essbase administration Services, Shared Services, Hyperion Provider server, Hyperion Essbase Server, Smart view

Designing Multidimensional Application & Database

  • Drafting Outlines
  • Adding members to Outline
  • Dimension and Member Properties
  • Dimension Types
  • Member Storage Properties

Practice Sessions: Trainees would have developed their first Multidimensional Application and Database

Building Dimensions

  • Setting Time and Account Dimension Properties
  • Attribute Dimension
  • UDA’s
  • Difference between UDA's and Attributes and Alias

Lab: Practice Sessions that covers everything that has been taught up till now

Dynamic Dimension Build & Data Load

  • Understanding Dimension Building Concepts
  • Data Load using Spread sheet Add-in Lock and Send
  • Understanding Data Loading
  • Creating Rules Files

Lab: Trainees would have developed Dimension Build and Data load using Build References and Add-in Lock and Send

Data Retrieving and Calculation

  • Data Load using Smart View
  • Calculating Essbase Databases
  • Developing Formulas
  • Defining Calculation Order
  • Understanding Intelligent Calculation
  • Developing Calculation Scripts

Lab: Practice Sessions that covers How to calculate Database using Formula and calc Script

Calculating Data & Security assignment

  • Integration with data Sources
  • Security Assignment
  • ASO and BSO Difference
  • Partitioning
  • Substitution Variable

Spreadsheet Add-in - Retrieve data, Changing data, Add-in Options, Formatting and creating reports using Add-in

Essbase Administration - Start/Stop Application and Database, View Server properties, Server Sessions, Server Data Locks, Locked Objects, View Server Log Files, Backup & Recovery

Essbase Server Files - Essbase Agent, Essbase Server, Essbase.cfg, Essbase.sec

Essbase Block Size - Calculate Block size and number of blocks, Index & Page files EXIT TEST

Hyperion essbase training is intended for:

  • Programmers

We guarantee learning at your convenience & pace.

  • Instant Access:
    Get instant access to self-paced training after signup.
  • Streaming video recording:
    Watch lessons any time at your schedule, free recording.
  • Exercises:
    Practical exercises help you test what you are learning as you go.
  • Free Demo:
    Sign up for free demo to check whether the course is right for you and interact with the faculty live.
  • Experienced Trainers:
    We only hire the industry’s best trainers
  • Live free interactive web sessions:
    Ask the Expert Shell Scripting trainers about the career prospects and clarify your questions any time after you complete the course.
  • Structured Curriculum Schedule:
    Progress with your complete daily interactive lessons and assignments.
  • Faculty Mentoring:
    Turn in daily and weekly homework for personalized feedback from faculty.
  • Virtual Office Hours:
    Live interaction with the faculty and other students around the world.
  • Hands on Live Projects:
    Work on live lab sessions to tackle real-world projects. Get 100% faculty guidance and ratings.


You may be also interested in

Register for FREE Demo

Fields marked with (*) are mandatory

* Name:
* Email:
* Phone:
* Location:
* Course:
* Enquiry:
* Captcha:


Client Feedback

Thanks, you guys provided the best online training in SAP BODS. The hands on training is very informative and helpful.

- David Sergi, Camaga Ltd; U.K