Training Formats
Audience
Prerequisites
Course Objectives
Course Topics
Next Courses
Related Courses
Hyperion Essbase Analytics 9.3 Bootcamp
Oracle University provides a downloadable eKit containing the training materials for this course.What you will learn:
In this course, you learn the principal techniques and theories for the design of Analytic Services block storage databases. You create a database outline, load data into the database, and analyze data with Smart View. You also create calculation scripts to calculate data for different scenarios. Design discussions and hands-on exercises help you practice the skills taught.
This course will assist in preparation for the Hyperion Certification exam Hyperion Essbase 9.3 Developer to earn your Hyperion System 9 BI+ 9.3 Administrator Certified Associate.
| Schedule/Purchase | Training Formats | Price ** | Duration | Course Materials | Instruction Language |
|---|---|---|---|---|---|
| View Schedule | Instructor-Led Training | AU$ 5905 | 5 Days | English | |
| View Schedule | Live Virtual Class | AU$ 5905 | 5 Days | English |
** excluding GST
Note: To have a more personalized experience, we invite you to: Log In!
Audience:
- Database Designers
- Developer
Prerequisites:
Required Prerequisites:
- Familiarity with Microsoft Windows and Excel
- Knowledge of client-server application concepts
- Hyperion Essbase 9.3 Fundamentals
Suggested Prerequisites:
Course Objectives:
- Build rules files for dimension builds and data loads
- Analyze data using Smart View
- Create calculation scripts
- Create advanced calculations
- Create Essbase Analytics databases
Course Topics:
Analytic Services Overview
- Multidimensional Analysis
- Hyperion Business Performance Management
- Analytic Services Solution
- Production Environment Components
Designing Applications and Databases
- Essbase Analytics Implementation Process
- Analyzing and Planning Implementations
- Creating Applications and Databases
- Creating Outline Structures
- Modifying Member Properties
Designing Data Descriptor Dimensions
- Data Descriptor Dimensions Overview
- Designing Time Dimensions
- Designing Scenario Dimensions
- Outline Calculations
- Designing Accounts Dimensions
Optimizing Data Descriptor Dimensions
- Creating Member Aliases
- Dimension Types
- Creating Period-to-Date Totals
- Optimizing Data Storage
- Enhancing Accounts Dimensions
Planning Dimension Design
- Business View Dimensions Overview
- Combining Business Views
- Planning Dimensions with Label Outlines
Creating Basic Dimension Build Rules Files
- Dimension Build Rules Files Overview
- Creating Dimension Build Rules Files
- Configuring Dimension Maintenance Settings
Creating Advanced Dimension Build Rules Files
- Advanced Dimension Build Rules Files Overview
- Creating Shared Members
- Manipulating Fields
- Creating User-Defined Attributes
Creating Attribute Dimensions
- Attribute Dimensions Overview
- Design Considerations
- Building Attribute Dimensions with Rules Files
- Assigning Attributes in Rules Files
Loading Data
- Creating Data Load Rules Files
- Selecting and Rejecting Records
- Capturing New Members
Getting Started with Smart View
- Hyperion Smart View Overview
- Configuring Data Sources
- Retrieving Data
- Setting the Point of View
Creating Smart View Reports
- Manipulating Multidimensional Data
- Updating Analytic Services Data
- Integrating Analytic Services Data with Microsoft Office
Data Storage and Calculation
- Calculation Overview
- 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 Explicitly
- Referencing Members Dynamically
- Creating Calculation Variables
Developing and Testing Calculation Scripts
- Script Development Process
- Loading to Upper-Level Members
- Intelligent Calculation
Normalizing Data
- Allocating Data
- Planning Data Normalization
- Normalizing Rates and Drivers
- Copying and Clearing Data