Hyperion Essbase Analytics 9.3.1 Bootcamp
Oracle University provides a downloadable eKit containing the training materials for this course.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
* Consider registering for Oracle Essbase 11.1.1 Bootcamp, if a convenient 9.3.1 class is not available.
| Schedule/Purchase | Training Formats | Price | Duration | Course Materials | Instruction Language |
|---|---|---|---|---|---|
| View Schedule | Instructor-Led Training | US$ 3,750 | 5 Days | English | English |
| View Schedule | Live Virtual Class | US$ 3,750 | 5 Days | English |
Note: To have a more personalized experience, we invite you to: Log In!
Audience:
- Database Administrators
- Business Intelligence Developer
- Developer
- Database Designers
Prerequisites:
Required 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