RSS
GoldenLine
Facebook
Nowoczesna Firma
Blog
English website
UK English version





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

Czas trwania

2 dni

Cena bazowa

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

Oracle Essbase 11.1.2 Bootcamp

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 uczestnictwa

W celu zgłoszenia chęci uczestnictwa w szkoleniu prosimy o kontakt telefoniczny pod numerem (22) 398 47 81

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.