Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3)

Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) Certification Training Course Overview

Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) training course will teaches you the principal techniques and theories for the design of calculations in block storage databases with Essbase Release 11.1.2.3. 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

Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) (16 Hours) Download Course Contents

Live Virtual Classroom
Group Training 1200
09 - 10 Aug 09:00 AM - 05:00 PM CST
(8 Hours/Day)

20 - 21 Sep 09:00 AM - 05:00 PM CST
(8 Hours/Day)

1-on-1 Training (GTR) 1400
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Essbase Overview
  • Essbase
  • Essbase Database Types
  • Business Scenario and Training Environment Overview
  • Block Storage Calculation Overview
Module 2: Data Storage and Calculation
  • Data Storage and Calculation Fundamentals
  • Database Statistics
  • Data Block Creation
  • Database Calculation Process
Module 3: Calculation Script Basics
  • Calculation Script Organization
  • Implementing a Script Development Process
  • Intelligent Calculation
Module 4: Dynamic Calculation Overview
  • About Dynamic Calculation
  • Dynamic Calculation Storage Options
  • Design Considerations for Dynamic Calculation
  • Design Considerations for Rates and Percentages
Module 5: Controlling the Calculation Process
  • Controlling Top-Down Calculation
  • Performance Considerations
  • Creating Complex Conditionals
Module 6: Copying and Clearing Data
  • Copying Data
  • Clearing Data with CLEARDATA
  • Clearing Data with CLEARBLOCK
Module 7: Developing Advanced Calculations
  • Creating Calculation Variables
  • Referencing Members Dynamically
Module 8: Developing Analytic Calculations
  • Typed Measures Overview
  • Creating Typed Measures
  • Calculating with Typed Measures
Module 9: Multidimensional Dynamic Calculations
  • Dynamic Calculation Order
  • Optimization Guidelines
Module 10: Normalizing Data
  • Loading Data to Upper-Level Members
  • Planning Data Normalization
  • Normalizing Rates and Drivers
Module 11: Performing Advanced Allocations
  • Allocating Data
  • Creating Multiple-Database Calculations
Module 12: Appendix: Essbase Architecture
  • Essbase Architecture Overview
  • Essbase Components by Tier
Download Course Contents

Request More Information

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.