Hyperion Training

[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

Thanks
[email protected]