Hyperion Essbase Analytics 9.3.1: Calculate Databases

Seminarziel

This course gives students the opportunity to learn the principal techniques and theories for the design of calculations in block storage databases with Essbase Release 9.3.1. Students review database structure and configuration; learn basic calculation building blocks, such as FIX and IF statements; 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. In addition, design discussions and hands-on practice sessions help reinforce the skills taught.
Learn To: o Develop and test calculation scripts o Develop advanced calculations o Leverage dynamic calculation o Normalize and allocate data o Describe block storage database structures

Zielgruppe

Entwickler, Datenbankdesigner, Datenbankadministratoren

Seminarinhalte

o Develop and test caclulation scripts o Develop advanced calculations o Optimize database performance through dynamic calculation o Normalize and allocate data o Describe block storage database structures
Sachgebiete:
- Essbase Overview
- Calculation Overview
- Developing and Testing Calculation Scripts
- Developing Advanced Calculations
- Calculating Dynamically
- Normalizing Data

Voraussetzungen

-Knowledge of client-server application concepts -Familiarity with basic Microsoft Windows skills -Besuch des Seminars "Hyperion Essbase Analytics 9.3.1 Bootcamp"

Hinweis

Empfohlene weitere Ausbildung:- "Hyperion Essbase 9.3.1: Deploy Aggregate Storage Databases"
- "Hyperion Essbase 9.3.1 for System Administrators"