Download PDF
of this course

Hyperion Financial Data Quality Management 11.1.2 Administration (HFDQMA)

  • Overview
  • Who Should Attend
  • Certifications
  • Prerequisites
  • Objectives
  • Content
  • Schedule
Course Overview

Duration: 3 Days

Price: SGD 3,165.00

In this course, you'll learn to implement Financial Data Quality Management (FDM), an advanced data transformation management solution. Explore a single, systematic process for loading source data from disparate systems into target analytical applications.

Learn To:

  • Create FDM applications.
  • Integrate FDM applications with target applications from disparate systems.
  • Import mappings.
  • Create import formats for source applications.
  • Create validation rules and entities.
  • Load data to target systems.
  • Apply financial controls to comply with Sarbanes-Oxley legislation.
  • Set up user and object security.

Hands-On Exercises

New concepts that you learn throughout this course will be demonstrated and reinforced through hands-on exercises. Expert Oracle instructors will provide support to ensure your understanding.

Live Virtual Class Format

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

 

Who Should Attend

  • Functional Implementer
  • Technical Administrator

Course Certifications

This course is part of the following Certifications:

Prerequisites

Required Prerequisites:

  • Oracle Hyperion Financial Management, Fusion Edition
  • Oracle Essbase
  • Knowledge of data sources for ONE of the following products:
  • Hyperion Enterprise

Course Objectives

  • Integrate FDM applications with target applications
  • Create FDM applications
  • Import mappings
  • Create import formats for source applications
  • Create validation rules and entities
  • Load data to target systems
  • Apply financial controls to comply with Sarbanes-Oxley legislation
  • Set up user and object security
  • Create scripts

Course Content

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

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

 

Course ID: HFDQMA


Show Schedule for 1 Month  3 Months  All 
Date Country Location Register