Oracle Essbase 11.1.1: Deploy Aggregate Storage Databases

Special Notices

Please note that Oracle courses running at London training centres are subject to a 10% surcharge.

Overview

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.

Learn to:

• Leverage aggregate storage and block storage for a complete Essbase deployment
• Create MDX member formulas
• Create time-intelligent outlines
• Create aggregate storage databases

This course is also suitable for customers using Hyperion Essbase Analytics 9.3.1.

Audience:

• Database Designers
• Technical Consultant
• Database Administrators
• Business Intelligence Developer
• Developer

Prerequisites

Required Prerequisites:

• Oracle Essbase 11.1.1: Bootcamp

Suggested Prerequisites:

• Oracle Hyperion Smart View 11.1.1 for Essbase

Delegates will learn how to

• Create aggregate storage databases
• Perform fundamental management tasks for aggregate storage databases
• Partition block and aggregate storage databases
• Write member formulas with MDX
• Build time-intelligent aggregate storage models
• Implement time intelligence for time period reporting
• Differentiate between block storage and aggregate storage databases

Course Outline

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