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: Deploy Aggregate Storage Databases (D71310GC10)

Tablet Lenovo (7"/8GB/WiFi/Android) gratis*!

Do szkoleń autoryzowanych Oracle 3, 4 lub 5 dniowych w formacie ILT, zamówionych w Database Consulting.
*Promocja ważna do wyczerpania zapasów lub do odwołania i nie łączy się z innymi promocjami ani zniżkami

Autoryzacja

Szkolenie autoryzowane Oracle

Format prowadzenia szkolenia

ILT - szkolenie klasyczne, w sali szkoleniowej, z trenerem

Kod szkolenia

D71310GC10

Dla kogo

  • Developer
  • Sales Consultants
  • Support Engineer
  • Technical Consultant

Czas trwania

4 dni

Cena bazowa

PLN 7112

Cel

  • Create ASO databases
  • Load data into ASO databases
  • Aggregate ASO data
  • Design aggregate storage (ASO) databases
  • Manage ASO databases
  • Construct member formulas
  • Build time-intelligent models
  • Describe custom calculations and allocations in aggregate storage databases

Opis

You learn the principles of aggregate storage database design, then how to build, load, report from, and manage aggregate storage databases, constructing the sixteen-dimension in-class database through a series of guided exercises. Learn to:Design, develop, and deploy aggregate storage databases Manage aggregate storage databases Construct variance, mix, and other member calculations using MDX Implement time intelligence for time period reporting Describe custom calculations and allocations in aggregate storage databases Additional topics give you an in-depth view of (and hands-on practice in) important elements of ASO development, including complex member formulas, time intelligence, partitioning, and the new features in Release 11.1.2, calculation templates and allocations.

Tematy

  1. Essbase Overview
    • The Oracle Enterprise Performance Management System
    • The Oracle BI Foundation Suite
    • The Essbase analytic solution
  2. Aggregate Storage Overview
    • Aggregate storage key characteristics and design considerations
    • Understanding the aggregate storage production cycle
    • Creating aggregate storage outline hierarchies
  3. Designing Data Descriptor Dimensions
    • Understanding data descriptor dimensions
    • Designing time, scenario, and accounts dimensions
  4. Designing Business View Dimensions
    • Understanding business view dimensions
    • Using attributes in database design
    • Designing primary and secondary hierarchies
  5. Loading Data
    • Understanding the aggregate storage data loading process
    • Using data load buffers
    • Loading data incrementally
  6. Creating Reports with Smart View
    • Understanding the Smart View architecture and user interface
    • Connecting to data sources
    • Working with shared and private connections
  7. Aggregating Data
    • Understanding the data aggregation process
    • Optimizing aggregations
    • Designing and running aggregations with the Aggregation Design wizard
  8. Managing Aggregate Storage Databases
    • Managing tablespaces
    • Exporting aggregate storage data
    • Optimizing data compression
    • Managing storage caches
    • Optimizing outline paging
    • Understanding disk space management options
    • Backing up aggregate storage applications
    • Viewing database statistics
  9. Creating Basic MDX Queries
    • MDX Overview
    • Understanding MDX formula components and structure
    • Identifying dimensions and members in MDX
    • Identifying tuples and sets
  10. Creating MDX Formulas
    • Using Member Formula Editor
    • Creating mix calculations
    • Using MDX conditional calculation tools
    • Deriving variances
  11. Time Intelligence Overview
    • Understanding the benefits of time intelligence
    • Establishing time intelligence in aggregate storage applications
    • Using the Create Date-Time Dimension wizard
  12. Building Time Intelligent Models
    • Creating a date-time dimension
    • Using standard calendar types
    • Defining member date ranges
  13. Loading Data Mapped to Dates
    • Identifying date hierarchies
    • Performing date-based data loads
    • Using date-string formats
  14. Creating Time Period Reports
    • Identifying linked attributes
    • Understanding periodic associations
    • Creating linked attribute reports
  15. Calculating Time-Based Metrics
    • Understanding time dimension designs
    • Creating analytics dimensions
    • Calculating time-based metrics
    • Using MDX date functions
  16. Time Balance Calculations
    • Using time balance tags
    • Using flow tags
  17. Partitioning Overview
    • Identifying data transfer methods
    • Understanding database partition types
    • Identifying the best partition type to use
    • Resolving partition overlaps
    • Following partitioning guidelines
  18. Creating Database Partitions
    • Designing partitions
    • Creating partitions
    • Evaluating partition designs
  19. Creating Custom Calculations
    • Understanding the workflow for creating custom calculations
    • Specifying calculation criteria
    • Writing and executing custom calculations
  20. Creating Allocations
    • Understanding the workflow for creating ASO allocations
    • Specifying allocation criteria
    • Specifying allocation and rounding methods
    • Executing allocations

Wymagania

    • Knowledge of Microsoft Windows and Excel
    • Knowledge of principles from Oracle Essbase Bootcamp course

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.