Hyperion Essbase Analytics 9.3.1 Bootcamp

What you will learn

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.

Learn To:
  • Create block storage databases
  • Develop database outlines manually and using rules files
  • Load data
  • Analyze data using Smart View
  • Calculate block storage databases
Audience
 Business Intelligence Developer
Database Administrators
Database Designers
Developer

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

Course Objectives
 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 Topics
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

Suggested Next Courses
 Hyperion Essbase Analytics 9.3: Calculate Databases
Hyperion Essbase 9.3.1: Deploy Aggregate Storage Databases
Hyperion Essbase 9.3.1 for System Administrators
Hyperion Integration Services 9.3.1: Create & Manage Data Structures