RSS
GoldenLine
Facebook
Nowoczesna Firma
Blog
Tablet 7"
z Androidem 4.4
Tablet 10 cali dla uczestników
dla uczestników



Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) (D67955GC20)

Autoryzacja

Szkolenie autoryzowane Oracle

Format prowadzenia szkolenia

ILT - szkolenie klasyczne, w sali szkoleniowej, z trenerem

Kod szkolenia

D67955GC20

Dla kogo

  • Business Intelligence Developer
  • Data Modelers
  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Data Warehouse Developer
  • Database Administrators
  • Database Designers
  • Technical Consultant

Czas trwania

2 dni

Cena bazowa

PLN 3556

Cel

  • Gain an understanding of the mechanisms by which Essbase stores and calculates data in block storage databases.
  • Learn the default database calculation order and investigate how it relates to block storage data structures.
  • Learn practical methods for developing and testing block storage calculations, from the simple to the complex.
  • Understand where use of dynamic calculation can improve database and calculation performance.
  • Focus calculations on specific subsets of data.
  • Compare the different calculation variables available and implement variables in calculation scripts
  • Investigate different methods for implementing and planning multidimensional allocations.

Opis

This Oracle Essbase 11.1.2: Calculate Block Storage Databases (11.1.2.3) training teaches you the principal techniques and theories for the design of calculations in block storage databases with Essbase Release 11.1.2.3. Expert Oracle University instructors will review database structure and configuration and teach you basic calculation building blocks, including FIX and IF statements.Learn To:Describe Essbase and block storage database structures.Develop and test calculation scripts.Develop advanced calculations.Optimize databases though dynamic calculations.Normalize and allocate data.Benefits to YouBy enrolling in this course, you'll become familiar with calculation script development methodology and how to correct common calculation errors. You'll 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. By participating in design discussions and hands-on practice sessions, you'll reinforce your understanding of important Essbase concepts.Please NoteThis course is also suitable for customers using Hyperion Essbase Analytics 9.3.1 or Oracle Essbase 11.1.x.

Tematy

  1. Essbase Overview
    • Essbase
    • Essbase Database Types
    • Business Scenario and Training Environment Overview
    • Block Storage Calculation Overview
  2. Data Storage and Calculation
    • Data Storage and Calculation Fundamentals
    • Database Statistics
    • Data Block Creation
    • Database Calculation Process
  3. Calculation Script Basics
    • Calculation Script Organization
    • Implementing a Script Development Process
    • Intelligent Calculation
  4. Dynamic Calculation Overview
    • About Dynamic Calculation
    • Dynamic Calculation Storage Options
    • Design Considerations for Dynamic Calculation
    • Design Considerations for Rates and Percentages
  5. Controlling the Calculation Process
    • Controlling Top-Down Calculation
    • Performance Considerations
    • Creating Complex Conditionals
  6. Copying and Clearing Data
    • Copying Data
    • Clearing Data with CLEARDATA
    • Clearing Data with CLEARBLOCK
  7. Developing Advanced Calculations
    • Creating Calculation Variables
    • Referencing Members Dynamically
  8. Developing Analytic Calculations
    • Typed Measures Overview
    • Creating Typed Measures
    • Calculating with Typed Measures
  9. Multidimensional Dynamic Calculations
    • Dynamic Calculation Order
    • Optimization Guidelines
  10. Normalizing Data
    • Loading Data to Upper-Level Members
    • Planning Data Normalization
    • Normalizing Rates and Drivers
  11. Performing Advanced Allocations
    • Allocating Data
    • Creating Multiple-Database Calculations
  12. Appendix: Essbase Architecture
    • Essbase Architecture Overview
    • Essbase Components by Tier

Wymagania

    • Oracle Essbase 11.1.2 Bootcamp

Zgłaszanie chęci uczestnictwa

W celu zgłoszenia chęci uczestnictwa w szkoleniu prosimy o pobranie i wypełnienie formularza lub wygenerowanie go ze strony, a następnie przeslanie faksem na numer (22) 398 47 82.

Pobierz formularz zgłoszenia w formacie DOC
Pobierz formularz zgłoszenia w formacie PDF

Jeśli potrzebują Państwo wsparcia, mają pytania lub chcą się upewnić odnośnie wyboru szkolenia prosimy o kontakt pod numerem 0-801 009 706. Nasi przedstawiciele chętnie odpowiedzą na Państwa pytania oraz pomogą w podjęciu trafnej decyzji.