HYPERION ESSBASE

HYPERION ESSBASE

Overview:
ESSBASE is a multidimensional database management system that provides a multidimensional database platform upon which to build analytic applications oracle ESSBASE is an OLAP (Online Analytical Processing) Server that provides an environment for deploying pre-packaged applications -Intersections of dimension members must exist in hierarchy before loading data.

Training Objectives of HYPERION ESSBASE:
Provide a real-time analytic infrastructure to support business intelligence and enterprise performance management (EPM) applications
This course is tailor made to focus on ESSBASE functionality which relates to the administration of a Hyperion Planning application.

Target Students / Prerequisites:
Students must have Knowledge on Microsoft Windows and Excel and Database Concepts

Course Contents:

Essbase Overview
Multidimensional Analysis
Oracle’s Enterprise Performance Management System
ESSBASE
Production Environment Components

Designing Applications and Databases
Creating Applications and Databases
Creating Outlines

Designing Data Descriptor Dimensions
Data Descriptor Dimensions Overview
Designing Time Dimensions
Designing Scenario Dimensions
Outline Calculations
Designing Accounts Dimensions
Testing Outline Calculations

Optimizing Data Descriptor Dimensions
Creating Member Aliases
Dimension Types
Creating Period-to-Date Totals
Dynamic Calc Members
Enhancing Accounts Dimensions
Optimizing Data Storage

Developing Dimension Designs
Business View Dimensions Overview
Attributes in Database Design
Combining Business Views
Developing Label Outlines

Creating Basic Dimension Build Rules Files
Rules Files Overview
Creating Dimension Build Rules Files
Configuring Dimension Maintenance Settings

Creating Advanced Dimension Build Rules Files
Advanced Dimension Build Rules Files Overview
Creating Shared Members
Manipulating Fields
Creating User-Defined Attributes
Creating Attribute Dimensions with Rules Files

Loading Data
Data Load Overview
Creating Data Load Rules Files
Selecting and Rejecting Records
Capturing New Members

Getting Started with Smart View
Navigating Smart View
Connecting to Data Sources
Creating Ad Hoc Grids
Setting the Point of View
Associating Data Sources with Worksheets
Creating Free-Form Grids

Creating Reports with Smart View
Updating ESSBASE Data
Integrating ESSBASE Data with Microsoft Office
Creating Shared Database Perspectives

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.