Oracle Essbase 11.1.2: Calculate Block Storage Databases

Special Notices

Please note that Oracle courses running at London training centres are subject to a 10% surcharge.

Overview

In this course, you learn the principal techniques and theories for the design of calculations in block storage databases with Essbase Release 11.1.2. You review database structure and configuration and learn basic calculation building blocks, such as FIX and IF statements. You learn a calculation script development methodology and how to correct common calculation errors. You 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. Design discussions and hands-on practice sessions help reinforce important Essbase concepts.

Learn To:

• Describe Essbase and block storage database structures
• Develop and test calculation scripts
• Develop advanced calculations
• Optimize databases though dynamic calculations
• Normalize and allocate data

This course is also suitable for customers using Hyperion Essbase Analytics 9.3.1 or Oracle Essbase 11.1.1.

Audience

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

Prerequisites

Required Prerequisites:

• Oracle Essbase 11.1.2 Bootcamp

Delegates will learn how to

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

Course Outline.

Essbase Overview

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

Data Storage and Calculation

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

Calculation Script Basics

• Calculation Script Organization
• Script Development Process
• Intelligent Calculation

Dynamic Calculation Overview

• About Dynamic Calculation
• Dynamic Calculation Storage Options
• Design Considerations for Dynamic Calculation
• Design Considerations for Rates and Percentages

Controlling the Calculation Process

• Controlling Top-Down Calculation
• Performance Considerations
• Creating Complex Conditionals

Copying and Clearing Data

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

Developing Advanced Calculations

• Creating Calculation Variables
• Referencing Members Dynamically

Developing Analytic Calculations

• Typed Measures Overview
• Creating Typed Measures
• Calculating with Typed Measures

Multidimensional Dynamic Calculations

• Dynamic Calculation Order
• Optimization Guidelines

Normalizing Data

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

Performing Advanced Allocations

• Allocating Data
• Creating Multiple-Database Calculations