Hyperion Financial Data Quality Management EE Administration (11.1.2.3)

Course DateLocationDaysPriceRegister
Call for Classroom Training Dates3 $3,630Register


Course DateLocationDaysPriceRegister
Nov 20, 2017Live Virtual - 10:00 am Eastern3 $3,480Register
Nov 29, 2017Live Virtual - 4:00 am Eastern3 $3,480Register
Oct 25, 2017Live Virtual - 9:00 am Eastern3 $3,480Register


Course DateLocationDaysPriceRegister
Self-Paced Learning3 $3,210Register


Hyperion Financial Data Quality Management EE Administration (11.1.2.3)

Description: This Hyperion Financial Data Quality Management EE Administration training will teach you how to implement Oracle Hyperion Financial Data Quality Management, Enterprise Edition (FDMEE), an advanced metadata and data transformation management solution. Explore a single, systematic process for loading source metadata and data from disparate systems into target analytical applications.

Duration: 3 Days

Learn to:

  • Define system, application, and user profiles.
  • Perform integration tasks.
  • Create import formats for file systems.
  • Set up locations, period mappings, and category mappings.
  • Create member mappings.
  • Define data load rules and load data to target applications.
  • Create check rules and check entities.
  • Process batches and manage reports.
  • Set up security.
  • Create import and event scripts.
  • Describe FDMEE integration with other source systems.

Audience:

  • Technical Administrator
  • Functional Implementer

Course Objectives:

  • Define system, application, and user profiles
  • Perform integration tasks
  • Create import formats for files systems
  • Set up locations, period mappings, and category mappings
  • Create member mappings
  • Define data load rules and load data to target applications
  • Create check rules and check entities
  • Process batches
  • Manage reports
  • Set up security
  • Create import and event scripts
  • Describe FDMEE integration with other source systems

Required Prerequisites:

  • Knowledge of data sources for Oracle Hyperion Financial Management
  • Knowledge of data sources for Oracle Hyperion Planning
  • Knowledge of data sources for Oracle Essbase

Topics:

  • 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 Rules
  • Data Load Rules Overview
  • Defining Data Load Rules for File-Based Data Loads
  • Loading Data into Multiple Periods
  • Running Data Rules and Checking Rule Status
  • Viewing Imported Data
  • Scheduling Data Load Rules
  • Processing Data in Data Load Workbench
  • Processing Data Overview
  • Importing Source Data
  • Validating Dimension Mappings
  • Fixing Validation Errors
  • Intersection Check Reports
  • Managing Data
  • Loading Data to Target Applications
  • Drilling Through from Target Applications
  • Setting Up Check Rules and Check Entities
  • Check Rules and Reports Overview
  • Creating Check Rule Groups and Check Rules
  • Assigning Check Rules to Locations
  • Verifying Check Rules
  • Check Entities Overview
  • Creating Check Entity Groups
  • Verifying Consolidations
  • 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
Course DateLocationDaysPriceRegister
Call for Classroom Training Dates3 $3,630Register


Course DateLocationDaysPriceRegister
Nov 20, 2017Live Virtual - 10:00 am Eastern3 $3,480Register
Nov 29, 2017Live Virtual - 4:00 am Eastern3 $3,480Register
Oct 25, 2017Live Virtual - 9:00 am Eastern3 $3,480Register


Course DateLocationDaysPriceRegister
Self-Paced Learning3 $3,210Register