Hyperion |Pega|Teradata|VMWare|Microstrategy|Datastage Training by experts

[ItzTraining]

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