| HYPERION Online Training|Comprehensive Hands on Experience |
|
HYPERION ESSBASE
· Essbase Overview - Multidimensional Analysis - Oracle’s Enterprise Performance Management System - Essbase - Production Environment Components
· Designing Applications and Databases - Essbase Implementation Process - Analyzing and Planning Implementations - Creating Applications and Databases - Creating Outlines
· Designing Data Descriptor Dimensions - Data Descriptor Dimensions Overview - 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
· Developing Dimension Designs - Business View Dimensions Overview - Attributes in Database Design - Combining Business Views - Developing Label Outlines
· Creating Basic Dimension Build Rules Files - 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 with Rules Files
· Loading Data - Data Load Overview - Creating Data Load Rules Files - Selecting and Rejecting Records - Capturing New Members
· Getting Started with Smart View - Navigating Smart View - Connecting to Data Sources - Creating Ad Hoc Grids - Setting the Point of View - Associating Data Sources with Worksheets - Creating Free-Form Grids
· Creating Reports with Smart View - Updating Essbase Data - Integrating Essbase Data with Microsoft Office - Creating Shared Database Perspectives - Creating Custom Reports
· Data Storage and Calculation - Calculation Overview - Database Calculation Order - Data Block Fundamentals - Data Blocks and the Index System - Interpreting 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 - Performance Considerations
· Referencing Members in Calculations - Referencing Members Explicitly - Referencing Members Dynamically - Creating Calculation Variables
· Developing and Testing Complex Calculation Scripts - Implementing a Script Development Process - Upper-Level Data Loads - Intelligent Calculation
· Normalizing Data - Allocating Data - Planning Data Normalization - Normalizing Rates and Drivers - Copying and Clearing Data
· Creating Attribute Dimensions - Attribute Dimensions Overview - Adding Attribute Dimensions to Outlines - Design Considerations
Hyperion Planning
· Getting Started with Hyperion System 9 Planning - Hyperion System 9 Planning Overview - Creating Planning Applications
· Defining Dimensions and Members - Hyperion System 9 Dimension Overview - Setting Up Currencies and Exchange Rates - Creating Time Periods, Scenarios, and Versions - Creating Entities - Creating Accounts - Creating User-Defined Dimensions, Attributes, and Member Formulas
· Setting Up Security - Setting Up Users and Groups - Setting Up Access Rights to Planning Applications - · Designing Data Forms - Creating Data Forms and Folders - Customizing Data Forms
· Entering Data in Hyperion System 9 Planning - Entering Data on the Web - Entering Data Using Hyperion System 9 Smart View for Office
· Adding Business Rules & Calculation Manager - Creating Business Rules - Building Run-Time Prompts for Business Rules - Adding Formulas to Business Rules
· Managing the Planning Process - Hyperion System 9 Planning Process Management - Creating Task Lists
· Analyzing Hyperion System 9 Planning Data with Hyperion System 9 BI+ Financial Reporting - Financial Reporting Overview - Navigating Reports in Workspace
Hyperion Finanicial Management (HFM)
· Introduction to Financial Management - Introduction - Navigating Financial Management
· Creating the Application Structure - Creating Applications - Setting Up Dimensions - Configuring Application Settings - Loading Metadata
· Adding Data to Your Application - Loading Data - Entering Data Using Data Grids - Creating Member Lists
· Setting Up Security - Adding Users and Groups - Assigning Access to Data and Documents
· Creating Data Forms and Workspaces - Creating Data Forms - Creating Workspaces
· Managing Intercompany Balances and Adjustments - Entering Intecompany Transactions - Adjusting Data with Journals - Processing Journals
· Adding Calculations With Rules - Rules Basics - Creating Expressions with Rules
· Consolidating Data - Managing the Review Cycle Using Process Control - Running Consolidations - Analyzing Data with Smart View - Automating Tasks
|
