Oracle Essbase 11.1.2: Calculate Block Storage Databases

Total time

Oracle Essbase 11.1.2: Calculate Block Storage Databases

Oracle University
Logo Oracle University
Provider rating: starstar_borderstar_borderstar_borderstar_border 2 Oracle University has an average rating of 2 (out of 1 reviews)

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.
  • View related products with starting dates: Oracle.

Description

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 …

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Oracle, CompTIA A+ / Network+ / Security+, IT Security, Retail (Management), and Security.

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.

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

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

There are no reviews yet.
  • View related products with reviews: Oracle.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.