Hyperion Essbase 7.1.2 Bootcamp

Description:

This course is designed to teach you the principal techniques and theory of Essbase 7.1.2 database design, including outline design alternatives, data load, and metadata build automation. You use the Essbase Administration Console interface for all course activities and Essbase Spreadsheet Add-in for ad hoc report creation. The class includes a multiday discussion on Essbase data structures and on creating, implementing, and optimizing calculation scripts. Exercises provide hands-on practice; case studies let you create a complete application.

This course will assist in preparation for the Hyperion Certification exam Hyperion Essbase 7.1.2 Consultant Certified Professional to earn your Hyperion Essbase 7.1.2 Professional.

Audience:

Developer

Objectives:

• Apply key design concepts to create a complete database
• Analyze data in Microsoft Excel, constructing and troubleshooting a variety of reports
• Describe the Essbase data structure and apply design concepts for optimal configuration
• Design database calculations for optimal performance
• Design and optimize allocation calculation scripts

Prerequisites:

Required Prerequisites:
Knowledge of client-server application concepts
Familiarity with Microsoft Windows and Excel

Topics:

Designing Outlines
Multidimensionality Overview
Essbase Overview
Creating Applications and Databases
Creating Dimensions and Members
Designing Time Dimensions
Designing Scenario Dimensions and Accounts Dimensions
Design Considerations for Data Descriptor Dimensions
Design Considerations for Business View Dimensions

Building Load Rules
Designing Large Dimensions with Label Outlines
Creating Dimension Build Load Rules
Setting the Load Method
Manipulating Column Fields
Creating Attribute Dimensions
Loading Data

Spreadsheet Reporting
Installing Essbase Spreadsheet Add-in
Connecting to Essbase
Retrieving Data
Managing Worksheet Options
Building Reports with Member Selection
Creating Reports with the Query Designer
Replicating Reports with Cascade
Protecting Formulas During Retrieval

Creating Basic Calculations
Designing Calculations in the Outline
Designing Calculation Scripts
Data Storage and Calculation Efficiency Overview
Designing Calculation Scripts
Returning Correct Results
Controlling the Top-Down Calculator
Generating Member Lists and Generating Member Lists
Optimizing the Outline with Dynamic Calculations

Designing and Optimizing Advanced Calculations
Creating and Testing Calculation Scripts
Correcting Calculation Behaviors
Manipulating Data Sets
Normalizing Data
Allocating Data
Optimizing Calculation Performance

Aggregate Storage Databases Overview
Aggregate Storage Overview
Aggregate Storage Kernel Overview
Creating Member Formulas
Analyzing Data with Hyperion Visual Explorer
MDX Overview
Identifying the Parts of a Query
Identifying Dimensions and Members
Selecting Multiple Members