Hyperion Financial Data Quality Management 11.1.2 Administration

Course Description

In this course, you learn to implement Financial Data Quality Management (FDM), an advanced data transformation management solution. You learn a single, systematic process for loading source data from disparate systems into target analytical applications. Exercises provide hands-on practice.

Skills Gained

• 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
• Integrate FDM applications with target applications

Who Can Benefit

• Functional Implementer
• Technical Administrator

Prerequisites

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

Syllabus

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