HYPERION FINANCIAL DATA QUALITY MANAGEMENT

HYPERION FINANCIAL DATA QUALITY MANAGEMENT

Overview:
Oracle Hyperion Financial Data Quality Management (FDM) is a packaged data transformation tool helps develop standardized financial data management processes user interface and powerful integration engine. It is the great tool for accountants and end users. For easy reconciliation of financial data.

Training Objectives of Hyperion FDM:
Implement Oracle Financial Data Quality Management (FDM) Creating import formats and mappings are introduced It is the great tool for accountants and end users. Advanced data transformation management solution

Target Students / Prerequisites:
• Knowledge of data sources for Oracle Hyperion Financial Management
• Knowledge of data sources for Oracle Hyperion Planning
• Knowledge of data sources for Oracle ESS base

Course Contents:

Product Orientation
Oracle’s Enterprise Performance Management System
Benefits and Features of FDM
ERP Integrator
Processing Data Overview

Navigating FDM
Accessing FDM
Working with the POV
Locking Out Users for Maintenance
Running Reports
Viewing Graphical Timelines

Creating FDM Applications
About FDM Applications
Creating Applications
Managing Applications

Integrating Applications
Integration Overview
Importing, Registering, and Configuring Adapters
Adding Machine Profiles
Configuring Application Settings
Configuring Integration Settings
Testing Integrations
Setting Up Standard Reports and Templates

Setting Up Control Tables and Locations
Viewing Control Tables
Managing Control Tables
Viewing Locations
Managing Locations
Setting Location Attributes
Searching Control Trees

Setting Up Mapping Tables
Mapping Dimension Members
Building Maps
Map Types
Processing Order
Building Maps Externally
Copying Maps
Sharing Dimension Maps
Setting Up Conditional Mapping
Building Import Formats
About Import Formats
Creating Import Groups
Creating Import Formats
Assigning Import Formats
Adding Import Expressions

Loading Data
About Loading Data
Importing Source Data
Working with Records
Validating Dimension Mappings
Loading Data to Target Systems
Drilling into Data
Drilling Through from Target Applications
8.Building Validation Rules
About Validation Rules and Reports
Creating Validation Rule Groups
Creating Validation Rules
Creating Validation Rules with Validation Editor
Assigning Validation Rules to Locations
Checking Validation Rules

Setting up Validation Entities
About Validation Entities
Creating Validation Entity Groups
Creating Validation Entities
Assigning Validation Entity Groups to Locations
Verifying Consolidations

Processing Batch Files
About Batch Processing
Setting Up Batch-Load Files
Processing Batches
Creating Batch Scripts
Scheduling Batch Scripts in Task Manager

Creating Logic Accounts
About Logic Accounts
Creating Logic Groups
Creating Simple Logic Accounts
Creating Complex Logic Accounts
Assigning Logic Groups to Locations

Loading FDM Journals
About FDM Journals
Creating Journal Templates
Adding Metadata Tags
Loading Journal Templates

Loading Data with multiload Files
About Multiload Files
Creating Multiload Excel Templates
Creating Multiload Text Files
Loading Multiload Files
Viewing Errors

Setting Up Security
About FDM Security
Security Levels
Setting Up Object Security
Setting Up User Security
Locking and Unlocking the Local POV Mode
Setting Up Report Group Security

Working with Financial Controls
About Financial Controls
Creating Controls Groups, Sections, and Questions
Deleting and Restoring Controls Groups, Sections, and Questions
Assigning Reviewer, Submitter, and Proxy Rights
Accessing Financial Controls
Selecting Application Settings for Financial Controls

Working with Import Scripts
About Scripting in FDM
Working with Scripting Components
Creating Import Scripts
Assigning Import Scripts to Import Formats
Applying Scripting Functions to Import Scripts
Working with Temporary Variables
Manually Executing Custom Custom Web Scripts

Working with Import Integration Scripts
About Import Integration Scripts
Creating Import Integration Scripts
Assigning Import Integration Scripts to Import Formats

Working with Event Scripts
About Event Scripts
Creating Event Scripts
Changing Import Formats Dynamically

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.