Tel: UK 0845 757 3888 | Ireland: 01 284 6796
Oracle Essbase 11.1.1 Calculate Databases
Course type Essentials (What does this mean?)
| Course title | Oracle Essbase 11.1.1 Calculate Databases |
|---|---|
| Delivery method |  Classroom |
| RRP | £1100 |
| Days/Duration | 2 |
| Code | OCHPEBCD |
- view dates / book course
- course description
- blogs
Course dates
We currently do not have public dates scheduled for this course.
Please contact us for details on a closed event for your company or to be added to the public course waitlist.
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.1. 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 calculation
- Normalize and allocate data
This course is also suitable for customers using Hyperion Essbase Analytics 9.3.1.
Audience:
- Data Modelers
- Data Warehouse Developer
- Business Intelligence Developer
- Technical Consultant
- Database Designers
- Data Warehouse Analyst
- Database Administrators
- Data Warehouse Administrator
Prerequisites
- Oracle Essbase 11.1.1: Bootcamp
Delegates will learn how to
- Describe block storage database structures
- Develop advanced calculations
- Develop and test calculation scripts
- Optimize database performance through dynamic calculation
- Normalize and allocate data
Course Outline
Essbase Overview
- Oracle’s Enterprise Performance Management System
- Essbase Overview
- Block Storage Calculation Overview
Data Storage and Calculation
- Data Storage and Block Creation
- Interpreting 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
- Loading Data to Upper-Level Members
- Planning for Normalization
- Normalizing Rates and Drivers
Performing Advanced Allocations
- Allocating Data
- Creating Multiple-Database Calculations
Related blogs
vSphere 5 CLI reference poster
Posted by Bryan O'Connor on 24 May 2012
The vCAP-DCA 5 is coming, and having a look at the blue print, there will be command line and as such the reference poster will be a good resource for revision
Connection Options for the vMA (VMware Management Assistant)
Posted by Bryan O'Connor on 23 May 2012
This article covers the various conn-options for the vMA
Let’s have a Fling
Posted by Bryan O'Connor on 22 May 2012
Not the type you thought, but an offering from VMware
Windows 7 Native Boot Adding the VHD to Bare Metal
Posted by Andrew Mallett on 21 May 2012
I have written before on the native boot feature of Windows 7 where it can boot to a VHD, Virtual Hard Drive. In this blog though we look at adding in a VHD to a completely clean disk with no OS ....
Microsoft Virtual Academy
Posted by Bryan O'Connor on 21 May 2012
Been on a Microsoft Offical Course and fancy some complentary information, have a look at Microsoft Virtual Academy.
