Hyperion Essbase Bootcamp

Designing Outlines

• Describing Essbase Analytic Services and Multidimensionality
• Creating Applications and Databases
• Creating Dimensions and Members
• Designing Time Dimensions
• Designing Scenario Dimensions
• Designing Accounts Dimensions
• Design Considerations for Data Descriptor Dimensions
• Design Considerations for Business View Dimensions

Building Load Rules

• Designing Large Dimensions with Label Outlines
• Load Rule Process
• Defining Load Rule Parameters
• Building Attribute Dimensions
• Troubleshooting Load Rules
• Loading Data

Spreadsheet Reporting

• Report Design Process Overview
• Retrieving Data
• Managing User Options
• Creating and Displaying Linked Objects
• Building Reports with Member Selection
• Creating Reports with the Essbase Query Designer
• Replicating Reports with the Cascade Function
• Protecting Formulas During Retrieval

Creating Basic Calculations

• Designing Calculations in the Outline
• Data Storage and Calculation Efficiency Overview
• Organizing Calculations
• Controlling the Top-Down Calculator
• Leveraging Hierarchy Intelligence
• Creating Variables
• Optimizing the Outline with Dynamic Calculations

Designing and Optimizing Advanced Calculations

• Creating and Testing Calculation Scripts
• Calculating When Data Is Loaded to Upper Levels
• Allocating Data
• Counting Calculations
• Optimizing Calculation Performance

Course Material Appendices Include:

• Overview of Aggregate Storage Databases
• Overview of Analytic Integration Services

For general training questions or to schedule classroom training, please contact Hyperion Education Support at 203-703-3535 or via education@hyperion.com.

MTG's Training Center is based in the New York Information Technology Center in the heart of New York's Financial District.  For information about convenient local transportation, lodging, and business services, please contact us at 212-824-2900 or info@mtgny.com.