Oracle Essbase 11.1.1 Calculate Databases

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 structuresDevelop and test calculation scriptsDevelop advanced calculationsOptimize databases though dynamic calculationNormalize and allocate data* This course is also suitable for customers using Hyperion Essbase Analytics 9.3.1.

• Essbase Overview
• Data Storage and Calculation
• Developing and Testing Basic Calculation Scripts
• Developing and Testing IF and FIX Calculation Scripts
• Copying and Clearing Data
• Calculating Dynamic References
• Developing Advanced Calculations
• Optimizing Databases Overview
• Optimizing Databases Through Dynamic Calculation
• Normalizing Data
• Performing Advanced Allocations

Klik hier voor een gedetailleerde onderwerpenlijst

Meer informatie?

Geïnteresseerd geraakt in deze opleiding
en wilt u weten welke (vergelijkbare) cursus(sen) u wel kunt volgen?


Vraag informatie aan

Gedetailleerde onderwerpenlijst

Hieronder vind u een gedetailleerd overzicht met onderwerpen die in de cursus Oracle Essbase 11.1.1 Calculate Databases behandeld zullen worden:

• 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

Alle vermelde prijzen zijn onder voorbehoud en exclusief BTW.