Training Curriculum for Oracle Essbase 

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