On-line training course catalogue

Hyperion Essbase Analytics 9.3.1 Bootcamp

Type of course: Classroom

Course details

Fee	£2750
Days	5
Course code	HYEAB

We currently do not have public dates scheduled for this course.
If you have a requirement for this course, please contact us for the latest course information.

Print this page | Download as Word document |

Overview

This course gives students the opportunity to learn the principal techniques and theories for the design of block storage databases with Essbase Release 9.3.1. Students create a database outline, load data into the database, analyze data with Smart View, and create calculation scripts. In addition, design discussions and hands-on practice sessions help reinforce the skills taught. 

Prerequisites

• Familiarity with basic Microsoft Windows skills
• Knowledge of client-server application concepts

 

Delegates will learn how to

• Create block storage databases
• Create dimensions using rules files
• Load data using rules files
• Analyze data with Smart View
• Describe multidimensional calculation
• Create basic database calculations

 Course outline

 

 Essbase Overview

• Multidimensional Analysis
• Oracle’s Enterprise Performance Management System
• Essbase--System 9
• Production Environment Components

Designing Applications and Databases

• Block Storage Implementation Process
• Analyzing and Planning Implementations
• Creating Applications and Databases
• Creating Outline Structures
• Modifying Member Properties

Designing Data Descriptor Dimensions

• 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

Planning Dimension Designs

• Combining Business Views
• Planning Dimensions with Label Outlines

Creating Basic Dimensions Build Rules Files

• Prepping Data Prep Editor
• Creating Dimensions using Rules Files
• Selecting Dimension Build Method
• Defining Field Properties
• Validating Dimension Build Rules Files
• Configuring Dimension Maintenance Settings

Creating Advanced Dimension Build Rules Files

• Creating Shared Members
• Manipulating Fields
• Creating User-Defined Attributes
• Creating Attribute Dimensions
• Adding Attribute Dimensions to Outlines
• Design Considerations for Attribute Dimensions
• Creating Attributes with Rules Files

Loading Data

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

Getting Started with Smart View

• Smart View Architecture
• Configuring Data Sources
• Retrieving Data
• Setting the Point of View

Creating Reports with Smart View

• Manipulating Multidimensional Data
• Updating Essbase Data
• Integrating Essbase Data with Microsoft Office

Data Storage and Calculation

• Database Calculation Order
• Data Block Fundamentals
• Data Blocks and the Index System
• 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
• Comparing FIX and IF Calculation Processes

Referencing Members in Calculations

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

 Examinations

 

 

Certification