HFM Training

                                       
                                              Hyperion Financial Management Training

for more details, pls contact WhatsApp- 8152873070, SanatanaSoft@gmail.com, 91- 815 287 3070

Hyperion Financial Management (HFM)  is a financial consolidation tool and  comprehensive, web-based application that delivers global collection, financial consolidation, reporting, and analysis in a single solution.

HFM Interview Questions

 * Class Delivery:  Online Class/ Class Room Training.

* Duration:  20 days, Week days- Mon to Fri, 7.30 AM to 8.30 AM, IST

* Learning Material: Complete material for Theory.

 * Lab:    Exercises/practices on real-time Projects.

 * About Hyperion Trainer: Hyperion Trainer is an Hyperion Real Time Expert in all Hyperion modules, have 15 years USA/India  experience  in  Hyperion Admin, Development, Support of Hyperion different modules. He is working in MNC. 

*  Audience/ Prerequisites for Hyperion Training 

1.Introduction to Financial Management

•   About Enterprise Performance Management

2.HFM Basics

• What is Meta Data and Data
• Dimensions - Standard dimensions and Custom Dimensions
• Application Profile Creation
• Application Creation – Classic / EPMA
• windows Menus
• Workspace

3.Loading Metadata from a File

• About Metadata Load Files
• Loading Metadata
• Manage Metadata
• Prepare own Metadata

4.Configuring Accounts and Custom Dimensions

• About Accounts and Custom Dimensions
• Setting Up Account Types and Hierarchies
• Setting Up Accounts and Custom Dimensions
• Intercompany Account and Other Account Properties

5.Setting Up Entities, Calendars, and Scenarios

• Setting up Entities
• Setting Up Calendars
• Setting Up Scenarios

6.Loading Data

• Loading Data Files
• Extracting Data
• Copying and Removing Data
• Explore grid settings
• exchange grid settings

7.Creating Data Forms

• About Data Forms
• Accessing the Form Builder
• Defining the Point of View
• Defining Columns and Rows
• Setting Row and Column Options
• Exporting Data to Spreadsheets

8.Entering Data Using Data Grids

• About Data Grids and Accessing Data Grids
• Changing the Grid Layout and Display
• Selecting Members for Dimensions
• Selecting Members
• Saving Grid Settings
• Entering Data and Filling Multiple Cells
• Spreading and Calculating Data
• Adding Cell Text and Line-Item Detail

9.Creating Member Lists in Financial Management

• About Member Lists
• System and User-Defined Member Lists
• Creating Member Lists
• Identifying Member Lists in a File
• Creating Static Member Lists
• Creating Dynamic Member Lists for the Entity Dimension and Other
• Dimensions
• Loading and Extracting Member Lists

10.Entering Intercompany Data

• About Intercompany Transactions
• Intercompany Account Balances
• Elimination Process
• Plug Accounts
• Intercompany Eliminations and the Value Dimension
• Setting Up Entities and Accounts for Intercompany Data
• Creating and Running Intercompany Matching Reports

11.Adjusting Data with Journals

• About Journals and Journal Benefits and Adjusting Data
• Journals Review Process and the Value Dimension
• Multiple Journal Postings, Accessing Journals and Opening Periods for
• Journal Entry
• Creating Journal Templates and Journal Balance Types
• Creating Journals and Entering Journal Data
• Creating, Previewing, Running and Viewing Adjustments with the Entity
• Details Report
• * Setting Journal Report Properties and Selecting Columns and Filters
• * Saving Journal Reports Locally and Remotely

12.Process Management & Running Consolidations

• Consolidation Process and Percentages
• Entering Consolidation Information Using Ownership Management
• Running Consolidations
• Checking Consolidation Status
• Data Translation
• Entering Exchange Rates

13.Analyzing Data Using Smart View

• About Smart View
• Smart View Installation and Components
• Connecting to a Data Source
• Entering Data with Web Data Forms
• Functions in Smart View

14.Rule Basics

• About Rules and Rules Syntax
• Rule Types and Rules Files
• Objects and Functions in Rules
• Assigning Values to Accounts
• Account Expressions
• Setting Values for Multiple Accounts
• Subcubes, Data Retrieval, and Rules
• Loading and Extracting Rules

15.Security

• Different Types of Security in HFM
• User creation & Group Creation
• Provisioning to Users and Groups
• Security Class creation and assigning Security Classes

FDMEE Training

                                        
                   Financial Data Quality Management Enterprise Edition Course content

for more details, pls contact WhatsApp- 8152873070, Contact@ITSoftwareGuru.com, 91- 815 287 3070

Financial Data Quality Management Enterprise Edition (FDMEE): Fully integrated web based data management tool created for Finance & Accounting users.The combination of Financial Data Quality Management (FDM) and ERP Integrator (ERPi).

* FDMEE  Notes

FDM Interview Questions

 * Class Delivery:  Online Class/ Class Room Training.

* Duration:  20 days, Week days- Mon to Fri, 7.30 AM to 8.30 AM, IST

* Learning Material: Complete material for Theory.

 * Lab:    Exercises/practices on real-time Projects.

 * About Hyperion Trainer: Hyperion Trainer is an Hyperion Real Time Expert in all Hyperion modules, have 15 years USA/India  experience  in  Hyperion Admin, Development, Support of Hyperion different modules. He is working in MNC. 

*  Audience/ Prerequisites for Hyperion Training 

Introduction to Hyperion Financial Data Quality Management Enterprise Edition.
           
         Product Orientation

•  FDMEE Overview
•  Key Benefits and Features of FDMEE
•  FDMEE Integration Process
•  Processing Data Overview
•  Accessing and Navigating in FDMEE

Preparing FDMEE Integrations

•  Integration Setup Overview
•  Setting Up the Application Root Folder
•  Defining Profiles
•  Setting Up Source Systems
•  Registering Target Applications

 Setting Up Import Formats for File Systems

•   Import Formats Overview
•  Creating Import Formats
•  Defining Import Format Mappings
•  Skipping Lines in Import Files
•  Concatenating Fields
•  Adding Import Expressions

Completing the Integration Setup

•  Locations Overview
•  Adding Locations
•  Setting Location Details and Integration Options
•  Periods and Categories Overview
•  Defining Period Mappings
•  Defining Category Mappings
•  Point of View Overview

Setting Up Data Load Mappings

•  Data Load Mappings Overview
•  Defining Data Load Mappings
•  Explicit Mappings
•  Mapping Rules
•  Processing Order
•  Building Maps Externally
•  Importing Mappings
•  Sharing Mappings


Defining and Executing Data Load Rulesc
Processing Batches

•  Batch Processing Overview
•  Adding Batch Definitions
•  Defining Batch Parameters
•  Executing Batches
•  Creating and Executing Open Batches
•  Scheduling Batches
•  Executing Batch Scripts

Reporting in FDMEE 

• FDMEE Reports Overview
•  Adding Report Groups
•  Running Reports
•  Reviewing and Adding Query Definitions
•  Generating XML Files
•  Creating Report Templates
•  Adding Report Definitions

Setting Up Security

•  FDMEE Security Overview
•  Setting Up FDMEE Security
•  Defining Role, Report, and Batch Security
•  Location Security
•  Adding Groups for Location Security
•  Assigning Users to Groups in Shared Services
•  Provisioning Users in Shared Services

Defining Import Scripts

•  Scripting in FDMEE Overview
•  Jython Basics
•  Accessing Script Editor
•  Creating Import Scripts
•  Assigning Import Scripts to Import Formats
•  Applying Import Script Functions
•  Using Temporary Variables in Import Scripts

Defining Mapping and Event Scripts

•  Mapping Scripts Overview
•  Jython Objects in Mapping Scripts
•  Setting Up Mapping Scripts
•  Event Scripts Overview
•  Creating Event Scripts
•  Changing Import Formats Dynamically
•  Using the File System Object in Event Scripts

FDMEE Integration with Other Source Systems

•  GL Integration Overview
•  Registering ERP Source Systems
•  Selecting Source Accounting Entities
•  Creating Import Formats for Accounting Entities
•  Setting Up the Integration for Source Systems
•  Drilling Through to Source Data
•  Importing Source Data from the Open Interface Table

Essbase Training Content

for more details, pls contact WhatsApp- 8152873070, SanatanaSoft@gmail.com,  91- 815 287 3070.

Essbase is a powerful and intuitive tool used to build highly useful analytical models,
reporting systems, and forecasting applications. The ease of use and power of Essbase

provide for a rapid development cycle.

Essbase Interview Questions

 * Class Delivery:  Online Class/ Class Room Training.

* Duration:  20 days, Week days- Mon to Fri, 7.30 AM to 8.30 AM, IST

* Learning Material: Complete material for Theory.

 * Lab:    Exercises/practices on real-time Projects.

 * About Hyperion Trainer: Hyperion Trainer is an Hyperion Real Time Expert in all Hyperion modules, have 15 years USA/India  experience  in  Hyperion Admin, Development, Support of Hyperion different modules. He is working in MNC. 

*  Audience/ Prerequisites for Hyperion Training 

I. Essbase Overview

·         Multidimensional Analysis

·         Oracle’s Enterprise Performance Management System

·         Oracle BI Suite Enterprise Edition Plus

·         Essbase

·         Production Environment Components

II. Designing Applications and Databases

·         Block Storage Implementation Process

·         Analyzing and Planning Implementations

·         Creating Applications and Databases

·         Creating Outline Structures

·         Modifying Member Properties

III. Designing Data Descriptor Dimensions

·         Data Descriptor Dimensions Overview

·         Designing Time Dimensions

·         Designing Scenario Dimensions

·         Outline Calculations

·         Designing Accounts Dimensions

·         Testing Outline Calculations

IV. Optimizing Data Descriptor Dimensions

·         Creating Member Aliases

·         Dimension Types

·         Creating Period-to-Date Totals

·         Dynamic Calc Members

·         Enhancing Accounts Dimensions

·         Optimizing Data Storage

V. Planning Dimension Designs

·         Business View Dimensions Overview

·         Combining Business Views

·         Planning Dimensions with Label Outlines

VI. Creating Basic Dimension Build Rules Files

·         Rules Files Overview

·         Creating Dimension Build Rules Files

·         Configuring Dimension Maintenance Settings

VII. Creating Advanced Dimension Build Rules Files

·         Advanced Dimension Build Rules Files Overview

·         Creating Shared Members

·         Manipulating Fields

·         Creating User-Defined Attributes

VIII. Loading Data

·         Data Load Overview

·         Creating Data Load Rules Files

·         Selecting and Rejecting Records

·         Capturing New Members

IX. Getting Started with Smart View

·         Smart View Overview

·         Configuring Data Sources

·         Creating Ad Hoc Reports

·         Setting the Point of View

X. Creating Reports with Smart View

·         Manipulating Multidimensional Data

·         Updating Essbase Data

·         Integrating Essbase Data with Microsoft Office

·         Customizing the User Experience

XI. 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

XII. Creating Calculation Scripts

·         Calculation Script Organization

·         Returning Correct Calculation Results

·         Troubleshooting CALC DIM Processes

XIII. Controlling the Calculation Process

·         Top-Down Calculation

·         Focusing Calculations with FIX Statements

·         Calculating Conditionally with IF Statements

·         Comparing FIX and IF Calculation Processes

XIV. Analyzing Member Attributes

·         Attribute Dimensions Overview

·         Adding Attribute Dimensions to Outlines

·         Design Considerations

·         Creating Attributes with Rules Files

XV. Analyzing Varying Attributes

·         Varying Attributes Overview

·         Creating Varying Attributes Overview

·         Viewing Varying Attribute Data

XVI. Task Automation

·         Automating Tasks Using MaxL

·         The MaxL Command Shell

·         MaxL Statements and Syntax

·         MaxL Username and Password Encryption

·         Debugging MaxL scripts

=================

Online Analytical Processing Overview

·         Data Transformation

·         Multidimensional View of Information

·         Dimensional Modeling

·         Data Cubes

·         Dimension Hierarchies

·         OLAP Solutions

Essbase architecture, components, and production cycle

·         Outlines

·         Load Rules

·         Calculation Scripts

·         Aggregations

·         Essbase Spreadsheet Add-in

·         Smart View

Block Storage Data Structure

·         Data Blocks and the Index System

·         Block Storage Database Statistics

·         Data Block Creation

·         Database Calculation Process