Hyperion Essbase Analytics 9.3: Calculate Databases

Description:

In this course, you learn to identify block storage data structures and design efficient calculations. You learn a calculation script development methodology and how to correct common calculation errors. You create simple and complex calculations using scripting functions and commands. You also learn to effectively leverage dynamic calculations to reduce database size and batch calculation times. Exercises provide hands-on practice.

Audience:

Developer

Objectives:

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

Prerequisites:

Required Prerequisites:
Hyperion Essbase Analytics 9.3 Bootcamp

Topics:

Calculation Overview
Analytic Services Overview
Calculation Basics
Database Calculation Order
Data Block Fundamentals

Developing and Testing Calculation Scripts
Calculation Script Organization
Script Development Process
Intelligent Calculation
Controlling Top-Down Calculation

Developing Advanced Calculations
Creating Complex Conditional Statements
Copying and Clearing Data
Calculation Variables
Referencing Members Dynamically

Optimizing Databases Through Dynamic Calculation
Dynamic Calculation Overview
Dynamic Calculation Storage Options
Dynamic Calculation Order
Optimization Guidelines

Normalizing Data
Loading Data to Upper-Level Members
Planning Normalization
Normalizing Rates and Drivers
Allocating Data
Multiple-Database Calculations