Oracle - Course Details

OraE1112:DASD Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases

Oracle Course Description:
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.
Oracle Course Duration:
Oracle Course Target Audience:
Developer,Sales Consultants,Support Engineer,Technical Consultant
Oracle Course Prerequisite:
Knowledge of Microsoft Windows and Excel,Knowledge of principles from Oracle Essbase Bootcamp course
Course Content:
  • Essbase Overview

    • The Oracle Enterprise Performance Management System
    • The Oracle BI Foundation Suite
    • The Essbase analytic solution

  • Aggregate Storage Overview

    • Aggregate storage key characteristics and design considerations
    • Understanding the aggregate storage production cycle
    • Creating aggregate storage outline hierarchies

  • Designing Data Descriptor Dimensions

    • Understanding data descriptor dimensions
    • Designing time, scenario, and accounts dimensions

  • Designing Business View Dimensions

    • Understanding business view dimensions
    • Using attributes in database design
    • Designing primary and secondary hierarchies

  • Loading Data

    • Understanding the aggregate storage data loading process
    • Using data load buffers
    • Loading data incrementally

  • Creating Reports with Smart View

    • Understanding the Smart View architecture and user interface
    • Connecting to data sources
    • Working with shared and private connections

  • Aggregating Data

    • Understanding the data aggregation process
    • Optimizing aggregations
    • Designing and running aggregations with the Aggregation Design wizard

  • 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

  • Creating Basic MDX Queries

    • MDX Overview
    • Understanding MDX formula components and structure
    • Identifying dimensions and members in MDX
    • Identifying tuples and sets

  • Creating MDX Formulas

    • Using Member Formula Editor
    • Creating mix calculations
    • Using MDX conditional calculation tools
    • Deriving variances

  • Time Intelligence Overview

    • Understanding the benefits of time intelligence
    • Establishing time intelligence in aggregate storage applications
    • Using the Create Date-Time Dimension wizard

  • Building Time Intelligent Models

    • Creating a date-time dimension
    • Using standard calendar types
    • Defining member date ranges

  • Loading Data Mapped to Dates

    • Identifying date hierarchies
    • Performing date-based data loads
    • Using date-string formats

  • Creating Time Period Reports

    • Identifying linked attributes
    • Understanding periodic associations
    • Creating linked attribute reports

  • Calculating Time-Based Metrics

    • Understanding time dimension designs
    • Creating analytics dimensions
    • Calculating time-based metrics
    • Using MDX date functions

  • Time Balance Calculations

    • Using time balance tags
    • Using flow tags

  • Partitioning Overview

    • Identifying data transfer methods
    • Understanding database partition types
    • Identifying the best partition type to use
    • Resolving partition overlaps
    • Following partitioning guidelines

  • Creating Database Partitions

    • Designing partitions
    • Creating partitions
    • Evaluating partition designs

  • Creating Custom Calculations

    • Understanding the workflow for creating custom calculations
    • Specifying calculation criteria
    • Writing and executing custom calculations

  • Creating Allocations

    • Understanding the workflow for creating ASO allocations
    • Specifying allocation criteria
    • Specifying allocation and rounding methods
    • Executing allocations