Hyperion Financial Data Quality Management Administration

QA Ltd.
Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough, United Kingdom

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

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



Prerequisites
Knowledge of data sources for one of the following products:
Hyperion System 9 Financial Management
Hyperion System 9 BI+ Essbase Analytics
Hyperion Enterprise
Delegates will learn how to
Create Financial Data Quality Management applications
Integrate Financial Data Quality Management applications with target 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 outline


Financial Data Quality Management Overview

Hyperion Business Performance Management
Financial Data Quality Management
Benefits of Financial Data Quality Management
Data-Loading Process


Setting Up Mapping Tables

Mapping Dimension Members
Building Maps in Financial Data Quality Management Web Client
Map Types
Building Maps Externally
Copying Mapping Tables
Assigning Parent Maps
Setting Up Conditional Mapping


Building Import Formats

About Import Formats
Creating Import Groups
Adding Fields to Import Groups
Assigning Import Formats
Adding Advanced Import Expressions
Sorting Columns
Working with Records


Loading Data

About Loading Data
Selecting Source Files
Importing Source Files
Validating Dimension Mappings
Loading Data to Target Systems
Drilling into Data


Building Validation Rules

About Validation Rules and Reports
Creating Validation Rule Groups
Creating Validation Rules
Creating Validation Rules with Validation Rule Logic Wizard
Assigning Validation Rules to Locations
Verifying Validation Rules


Setting Up Validation Entities

About Validation Entities
Creating Validation Entity Groups
Creating Validation Entities
Assigning Validation Entity Groups to Locations


Creating Logic Accounts

About Logic Accounts
Creating Logic Groups
Creating Simple Logic Accounts
Creating Custom Logic Expressions
Looking Up Source Account Values
Creating Complex Logic Accounts


Loading Financial Data Quality Management Journals

About Financial Data Quality Management Journals


Navigating Financial Data Quality Management

Accessing Workbench
Accessing Web Client
Web Client Interface
Setting the POV
Locking Out Users for Maintenance


Creating Financial Data Quality Management Applications

About Financial Data Quality Management Applications
Data Requirements
Application Building Process
Creating Applications
Selecting Database Settings
Directory Structure of Applications
Managing Applications


Integrating Applications

Integration Overview
Working with Adapters
Adding Machine Profiles
Verifying Application Settings
Updating Integration Settings
Mapping Dimensions Between Applications
Testing the Integration
Importing Standard Reports and Templates


Setting Up Control Tables and Locations

Viewing Control Tables
Modifying Control Tables
Viewing Locations
Adding Locations
Setting Location Attributes
Searching Control Trees
Creating Journal Templates
Loading Journal Templates


Loading Data with Multiload Files

About Multiload Files
Creating Multiload Text Files
Creating Multiload Excel Templates
Loading Multiload Files


Changing Dimension Mappings

About Map Converter
Changing Dimension Mappings to Target Applications


Setting Up Security

Levels of Security
Setting Up User Security
Setting Up Object Security


Applying Financial Controls

About Financial Controls
Adding Control Groups
Adding Sections
Adding Questions
Adding Reviewers and Proxies
Adding Memos and Documentation
Certifying Data
Completing Questionnaires in Process Explorer


Creating Import Scripts

Scripting Components in Financial Data Quality Management
About Import Scripts
Writing Import Scripts
Creating Import Scripting Functions
Storing and Retrieving Temporary Variables


Creating Import Integration Scripts

About Import Integration Scripts
Writing Import Integration Scripts
Assigning Import Integration Scripts to Import Formats


Creating Event Scripts

About Event scripts
Writing Event Scripts
Changing Import Functions Dynamically ...''

Elements of this syllabus are subject to change.

Phone:0844 871 2080

School Address:

TEL: 0844 871 2080
E-mail us: info@qa.com

Jobs & Resumes: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Houses & Roommates: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Travel Agencies: Birmingham, Bristol, Edinburgh, Leeds, London, Manchester,

Search other schools for Hyperion Financial Data Quality Management Administration training resources.

Securing Networks with Cisco Routers and Switches v1.0
Troubleshooting Cisco Unified Communications Systems
Unified Contact Center Express and Unified IP IVR Deployment
Hyperion Essbase Fundamentals
Hyperion Essbase for System Administrators
Hyperion Essbase Analytics Bootcamp
Hyperion Financial Management for Interactive Users
Hyperion Financial Management 1
Hyperion Financial Management 2
Hyperion Financial Management 3
Hyperion Financial Management 4
Hyperion Financial Reporting for Financial Management

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself.