Hyperion Financial Data Quality Management 11.1.1 Administration (Self-Study Course)

 

Prerequisites

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

Course Objectives

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

Product Description

  • Product Orientation
    • Oracle's Enterprise Performance Management System
    • Oracle's Business Intelligence Suite Enterprise Edition Plus
    • FDM
    • Processing Data Through FDM
  • Navigating FDM
    • Accessing FDM
    • Setting the POV
    • Locking Out Users for Maintenance
    • Running Reports
    • Viewing Graphical Timelines
  • Creating FDM Applications
    • About FDM Applications
    • Creating Applications
    • Modifying, Removing, and Adding Applications
  • Integrating Applications
    • About Integration
    • Working with Adapters
    • Adding Machine Profiles
    • Verifying Application Settings
    • Updating Integration Settings
    • Testing Integrations
    • 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
  • 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
    • Building Import Formats
    • Assigning Import Formats
    • Adding Import Expressions
  • Loading Data
    • About Loading Data
    • Selecting Data Files
    • Importing Data Files
    • Working with Records
    • Validating Dimension Mappings
    • Loading Data to Target Systems
    • Drilling into Data
    • Drilling Back from Target Applications
  • Building Validation Rules
    • About Validation Rules and Reports
    • Creating Validation Groups
    • Creating Validation Rules
    • Creating Validation Rules in 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 Loader
    • Setting Up Batch Load Files
    • Processing Batches
    • Creating Batch Scripts
    • Scheduling Batch Files in Task Manager
  • Creating Logic Accounts
    • About Logic Accounts
    • Creating Logic Groups
    • Creating Simple Logic Accounts
    • Creating Complex Logic Accounts
  • 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 Data Load Errors
  • Setting Up Security
    • About FDM Security
    • Security Levels
    • Setting Up Object Security
    • Setting Up User Security
    • Migrating Users to Shared Services
    • Locking and Unlocking the Point of View Mode
    • Setting Up Report Groups Security
  • Working with Financial Controls
    • About Financial Controls
    • About Financial Controls
    • Deleting and Restoring Groups, Sections, and Questions
    • Assigning Reviewer, Submitter, and Proxy Rights
    • Accessing Financial Controls
    • Adding Memos and Attaching Documentation
    • Reviewing and Submitting Questions
    • Selecting Application Settings for Financial Controls
  • Working with Import Scripts
    • About Scripting in FDM
    • Scripting Components
    • Creating Import Scripts
    • Assigning Import Scripts to Import Formats
    • Applying Scripting Functions to Import Scripts
    • Storing and Assigning Temporary Variables
    • Assigning Custom Web Scripts to Menu Items
  • 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
    • Changing Other Location Attributes Dynamically

Price on request