Oracle Essbase 11.1.2 Bootcamp

Course Outline

Topics

• Essbase Overview
• Designing Applications and Databases
• Designing Data Descriptor Dimensions
• Optimizing Data Descriptor Dimensions
• Developing Dimension Designs
• Creating Basic Dimension Build Rules Files
• Creating Advanced Dimension Build Rules Files
• Loading Data
• Getting Started with Smart View
• Creating Reports with Smart View
• Data Storage and Calculation
• Creating Calculation Scripts
• Controlling the Calculation Process
• Referencing Members in Calculations
• Developing and Testing Complex Calculation Scripts
• Normalizing Data
• Creating Attribute Dimensions
• Analyzing Varying Attributes
• Analyzing Text and Dates

• Multidimensional Analysis
• Oracle’s Enterprise Performance Management System
• Oracle BI Foundation Suite
• Essbase
• Production Environment Components

Designing Applications and Databases

• Essbase Implementation Process
• Analyzing and Planning Implementations
• Creating Applications and Databases
• Creating Outlines

Designing Data Descriptor Dimensions

• Data Descriptor Dimensions Overview
• Designing Time Dimensions
• Designing Scenario Dimensions
• Outline Calculations
• Designing Accounts Dimensions
• Testing Outline Calculations

Optimizing Data Descriptor Dimensions

• Creating Member Aliases
• Dimension Types
• Creating Period-to-Date Totals
• Dynamic Calc Members
• Enhancing Accounts Dimensions
• Optimizing Data Storage

Developing Dimension Designs

• Business View Dimensions Overview
• Attributes in Database Design
• Combining Business Views
• Developing Label Outlines

Creating Basic Dimension Build Rules Files

• Rules Files Overview
• Creating Dimension Build Rules Files
• Configuring Dimension Maintenance Settings

Creating Advanced Dimension Build Rules Files

• Advanced Dimension Build Rules Files Overview
• Creating Shared Members
• Manipulating Fields
• Creating User-Defined Attributes
• Creating Attribute Dimensions with Rules Files

Loading Data

• Data Load Overview
• Creating Data Load Rules Files
• Selecting and Rejecting Records
• Capturing New Members

Getting Started with Smart View

• Navigating Smart View
• Connecting to Data Sources
• Creating Ad Hoc Grids
• Setting the Point of View
• Associating Data Sources with Worksheets
• Creating Free-Form Grids

Creating Reports with Smart View

• Updating Essbase Data
• Integrating Essbase Data with Microsoft Office
• Creating Shared Database Perspectives
• Creating Custom Reports

Data Storage and Calculation

• Calculation Overview
• Database Calculation Order
• Data Block Fundamentals
• Data Blocks and the Index System
• Interpreting Database Statistics
• Data Block Creation
• Database Calculation Process

Creating Calculation Scripts

• Calculation Script Organization
• Returning Correct Calculation Results
• Troubleshooting CALC DIM Processes

Controlling the Calculation Process

• Top-Down Calculation
• Focusing Calculations with FIX Statements
• Calculating Conditionally with IF Statements
• Performance Considerations

Referencing Members in Calculations

• Referencing Members Explicitly
• Referencing Members Dynamically
• Creating Calculation Variables

Developing and Testing Complex Calculation Scripts

• Implementing a Script Development Process
• Upper-Level Data Loads
• Intelligent Calculation

Normalizing Data

• Allocating Data
• Planning Data Normalization
• Normalizing Rates and Drivers
• Copying and Clearing Data

Creating Attribute Dimensions

• Attribute Dimensions Overview
• Adding Attribute Dimensions to Outlines
• Design Considerations

Analyzing Varying Attributes

• Varying Attributes Overview
• Creating Varying Attributes
• Viewing Varying Attribute Data

Analyzing Text and Dates

• Typed Measures Overview
• Enabling Typed Measures
• Creating Text Measures
• Creating Date Measures
• Viewing Typed Measures
• Calculations Based on Typed Measures