Essbase Training

Course Objectives:


* Create Block storage databases

* Create Aggregate storage databases

* Create dimensions using rules files

* Load data using rules files

* Analyze data with Smart View

* Describe multidimensional calculation

* Create basic & advanced database calculations

* Create basic & advanced report scripts

* Create & manage partitions

* Optimize & maintain BSO/ASO cubes (System Administration)

* Setup security using Essbase stand-alone mode & Shared services mode (System Administration)

* Analyze dimension attributes

* Analyze non-numeric data


Course Topics:


Essbase Overview

* Multidimensional Analysis/Understanding Multidimensional databases (OLAP Vs OLTP)

* Oracle’s Enterprise Performance Management System

* Essbase

* Production Environment Components.

Designing Applications and Databases

* Essbase Implementation Process

* Analyzing and Planning Implementations

* 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

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

* Creating Report scripts

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 Custom Reports

Data Storage and Calculation

* Calculation Overview

* Database Calculation Order

* Data Block Fundamentals

* Data Blocks and the Index System

* Interpreting Database Statistics

* Data Block Creation

* Database Calculation Process

Creating Calculation Scripts

* Calculation Script Organization (using both Essbase calculation script editor & EPMA Calculation Manager)

* Returning Correct Calculation Results

* Troubleshooting CALC DIM Processes

Controlling the Calculation Process

* Top-Down Calculation

* Focusing Calculations with FIX Statements

* Calculating Conditionally with IF Statements

* Performance Considerations

Developing and Testing Complex Calculation Scripts

* Implementing a Script Development Process

* Upper-Level Data Loads

* Intelligent Calculation

Normalizing Data

* Allocating Data

* Planning Data Normalization

* Normalizing Rates and Drivers

* Copying and Clearing Data

Creating Attribute Dimensions

* Attribute Dimensions Overview

* Adding Attribute Dimensions to Outlines

* Design Considerations

Additional topics

* Overview on new features in Essbase 11.1.2.3.500 & beyond

* Comparison between ASO & BSO storage types

* Designing a sample application using ASO

* Creating database partitions using Essbase partition methods

* Setup & Manage security using Essbase stand-alone & Shared services mode

* Overview on Essbase Excel Add-in (if not covered as part of Smartview topic)

* Optimize Essbase cubes (BSO & ASO), load rules, calculation scripts, report scripts, etc

* Overview on Hyperion Financial Reports

* Overview on Data Mining using Essbase

* Overview on other multidimensional solutions/tools in the market with preferably a comparison/differences chart

* Sharing of best practices, standards & guidelines and techniques (estimation, requirement gathering, upgrade, support & maintenance)

**All the above listed courses are expected to be delivered with a case study or hands-on exercise (preferable), wherever applicable.