Oracle Essbase 11.1.2: Calculate Block Storage Databases (

Download Course Contents

Oracle Essbase 11.1.2: Calculate Block Storage Databases ( Course Overview

Oracle Essbase 11.1.2: Calculate Block Storage Databases ( training course will teaches you the principal techniques and theories for the design of calculations in block storage databases with Essbase Release In this training class, you will be taught how to review database structure and configuration and you will also learn basic calculation building blocks, including FIX and IF statements.

Target Audience:

  • Administrator
  • Analyst
  • Architect
  • Database Administrator
  • Developer
  • Implementer

This is a Rare Course and it can be take up to 3 weeks to arrange the training.

  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Essbase Overview
  • Essbase
  • Essbase Database Types
  • Business Scenario and Training Environment Overview
  • Block Storage Calculation Overview
  • Data Storage and Calculation Fundamentals
  • Database Statistics
  • Data Block Creation
  • Database Calculation Process
  • Calculation Script Organization
  • Implementing a Script Development Process
  • Intelligent Calculation
  • About Dynamic Calculation
  • Dynamic Calculation Storage Options
  • Design Considerations for Dynamic Calculation
  • Design Considerations for Rates and Percentages
  • Controlling Top-Down Calculation
  • Performance Considerations
  • Creating Complex Conditionals
  • Copying Data
  • Clearing Data with CLEARDATA
  • Clearing Data with CLEARBLOCK
  • Creating Calculation Variables
  • Referencing Members Dynamically
  • Typed Measures Overview
  • Creating Typed Measures
  • Calculating with Typed Measures
  • Dynamic Calculation Order
  • Optimization Guidelines
  • Loading Data to Upper-Level Members
  • Planning Data Normalization
  • Normalizing Rates and Drivers
  • Allocating Data
  • Creating Multiple-Database Calculations
  • Essbase Architecture Overview
  • Essbase Components by Tier
Live Online Training (Duration : 16 Hours) Fee On Request
Group Training Date On Request
1-on-1 Training
4 Hours
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Comfort Track

If you think 16 hours is too fast, we can offer Comfort Track for 32 hours

Course Prerequisites
  • Basic Computer Knowledge.
  • Gain an understanding of the mechanisms by which Essbase stores and calculates data in block storage databases.
  • Learn the default database calculation order and investigate how it relates to block storage data structures.
  • Learn practical methods for developing and testing block storage calculations, from the simple to the complex.
  • Understand where use of dynamic calculation can improve database and calculation performance.
  • Focus calculations on specific subsets of data.
  • Compare the different calculation variables available and implement variables in calculation scripts
  • Investigate different methods for implementing and planning multidimensional allocations.

Request More Information

Add Name and Email Address of participant (If different from you)


Yes, fee excludes local taxes.
The Fee includes:
  • Official courseware
Yes, Koenig Solutions is a Oracle Learning Partner