Oracle Essbase 11.1.1 Calculate Databases

This course gives students the opportunity to learn the principal techniques and theories for the design of calculations in block storage databases with Essbase Release 11.1.1. Students review database structure and configuration; learn basic calculation building blocks, such as FIX and IF statements; learn how to effectively leverage dynamic calculations to optimize database performance; and create advanced calculation scripts, such as allocations, cross-database calculations, and multidimensional range calculations. In addition, design discussions and hands-on practice sessions help reinforce the skills taught.

Learn To:

• Develop advanced calculations
• Leverage dynamic calculation
• Normalize and allocate data
• Describe block storage database structures
• Develop and test calculation scripts

* This course is also suitable for customers using Hyperion Essbase Analytics 9.3.1.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Audience

• Business Intelligence Developer
• Data Modelers
• Data Warehouse Developer
• Database Designers
• Data Warehouse Administrator
• Data Warehouse Analyst
• Technical Consultant
• Database Administrators

Course Topics Essbase Overview

• Oracle’s Enterprise Performance Management System
• Essbase Overview
• Block Storage Calculation Overview

Data Storage and Calculation

• Data Storage and Calculation
• Database Statistics
• Data Block Creation
• Calculation Process Overview

Developing and Testing Basic Calculation Scripts

• Calculation Script Organization
• Script Development Process
• Intelligent Calculation

Developing and Testing IF and FIX Calculation Scripts

• Controlling Top-Down Calculation
• Comparing FIX and IF Calculation Processes

Copying and Clearing Data

• Copying Data
• Clearing Data with CLEARDATA
• Clearing Data with CLEARBLOCK

Calculating Dynamic References

• Referencing Members Dynamically
• Creating Calculations Based on Typed Measures

Developing Advanced Calculations

• Creating Complex Conditionals
• Creating Calculation Variables

Optimizing Databases Overview

• Dynamic Calculation Overview
• Dynamic Calculation Storage Options

Optimizing Databases Through Dynamic Calculation

• Dynamic Calculation Order
• Optimization Guidelines

Normalizing Data Overview

• Loading Data to Upper-Level Members
• Planning for Normalization
• Normalizing Rates and Drivers

Performing Advanced Allocations

• Allocating Data
• Creating Multiple-Database Calculations

Course Objectives

• Describe block storage database structures
• Develop advanced calculations
• Develop and test calculation scripts
• Normalize and allocate data
• Optimize database performance through dynamic calculation