Hyperion Essbase Online Training

HYPERION ESSBASE

• · Essbase Overview

- Multidimensional Analysis

- Oracle’s Enterprise Performance Management System

- 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