Oracle - Course Details

OraE1111:DASD Oracle Essbase 11.1.1: Deploy Aggregate Storage Databases

Oracle Course Description:
This course shows you how to deploy aggregate storage databases in Oracle Essbase. You learn the fundamental differences between block storage and aggregate storage databases and requirements for database design and deployment. You learn how to convert existing block storage database outlines to aggregate storage and how to create aggregate storage databases. You also learn about database partitioning as it relates to aggregate storage databases and about MDX for building member formulas. You finish with an in-depth discussion of time intelligence. Exercises provide hands-on practice.
Oracle Course Duration:
Oracle Course Target Audience:
Business Intelligence Developer,Database Administrators,Database Designers,Developer,Technical Consultant
Oracle Course Prerequisite:
Course Content:
  • Essbase Overview

    • Oracle's Enterprise Performance Management System
    • Oracle BI Suite Enterprise Edition Plus
    • Essbase Analytic Solution
    • Data Analysis Needs
    • Aggregate Storage Overview

  • Creating Aggregate Storage Databases

    • Aggregate Storage Production Cycle
    • Designing Aggregate Storage Outline Hierarchies
    • Designing Alternate Hierarchies
    • Converting Block Storage to Aggregate Storage

  • Loading and Aggregating Data

    • Loading Aggregate Storage Data
    • Data Aggregation
    • Optimizing Aggregations
    • Designing and Running Aggregations

  • Managing Aggregate Storage Databases

    • Tablespace Management
    • Disk Space Management
    • Exporting Data
    • Data Compression
    • Optimizing Aggregate Storage Cache
    • Optimizing Outline Paging
    • Partially Clearing Data
    • Backing Up Aggregate Storage Applications

  • Partitioning Overview

    • Data Transfer Methods
    • Database Partitioning
    • Partition Types
    • Partitioning Guidelines
    • Partition Overlaps
    • Partition Choices

  • Creating Database Partitions

    • Outline Differences
    • Creating Partitions
    • Aggregate Storage Partition Designs
    • Design Considerations

  • Creating Basic MDX Queries

    • MDX Overview
    • MDX Queries
    • Identifying Dimensions and Members
    • Selecting Multiple Members
    • MDX Data Model: Tuples and Sets
    • Managing Multiple Sets

  • Converting Block Storage Member Formulas

    • Elements Common to Block Storage and MDX Formulas
    • Elements Unique to MDX Formulas
    • Function Return Types
    • Converting Formulas to MDX
    • Aggregate Storage Calculation Order
    • Considerations for Custom Functions and Macros

  • Creating Basic MDX Formulas

    • Member Formula Editor
    • Accessing MDX Help Documentation
    • Creating Mix Calculations
    • Conditional Calculation Tools
    • Deriving Variances

  • Time Intelligence Overview

    • Time Intelligence in Aggregate Storage
    • About the Create Date-Time Dimension Wizard
    • Time Intelligence Benefits

  • Building Time Dimension Models

    • Creating Date-Time Dimensions
    • Supported Calendar Types
    • Date Ranges

  • Loading Data Mapped to Dates

    • Date Hierarchies
    • Date-Based Data Loads
    • Date-String Formats
    • Loading Time-Based Data

  • Creating Time Period Reports

    • Linked Attributes
    • Periodic Associations
    • Linked Attribute Mapping
    • Linked Attribute Mapping: Example
    • Creating Linked Attribute Reports

  • Calculating Time-Based Metrics

    • Time Dimension Designs
    • Creating Analytics Dimensions
    • Calculating Time-Based Metrics in Generic Time Designs
    • MDX Date Functions

  • Time Balance Calculations

    • Time Balance Tags
    • Flow Tags