Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases

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.

Audience

• Sales Consultants
• Technical Consultant
• Support Engineer
• Developer

Course Topics 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

Course Objectives

• 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