Essbase Hyperion

Class Room and Remote Access Server.

Topics Covered

Radix INFO Offers Oracle Essbase :

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

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
Data Retrieving and Calculation

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

Calculatating 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

Who should attend

Any MBA Graduate

Pre-requisites

2+ Years Industrial Experience.

What you need to bring

Laptop or Notebook and Pen

Key Takeaways

Real time Exposure.