Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases

Course Details
Code: D71310GC10
Tuition (USD): $3,908.00 • Classroom (4 days)
Course Details
GSA (USD): $3,083.12 • Classroom (4 days)

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.

Skills Gained

  • 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


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

Course Details

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
Contact Us 1-800-803-3948
Contact Us Live Chat
FAQ Get immediate answers to our most frequently asked qestions. View FAQs arrow_forward