What you will learn
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
|
Prerequisites
Hyperion Essbase Analytics 9.3 Bootcamp
|
Course 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
|
Course 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
|
Suggested Next Courses
Hyperion Essbase 9.3 for System Administrators
|
Related Courses
Hyperion Essbase 9.0: Deploy Aggregate Storage Databases
|