1. Administrator's Guide
  2. Integrating Data
  3. Loading Data
  4. Using the Data Load Workbench

Using the Data Load Workbench

The Data Load Workbench feature provides a framework to import, view and verify, and export data from source systems in the Oracle Hyperion Financial Data Quality Management, Enterprise Edition.

Key features of the Workbench include:

  • Interactive Load Process with options for Import, Validate, Export, and Check.

  • Provision to view Source (All)/Source (Mapped)/Target/Source and Target values

  • PTD/YTD Value display for ready reference

  • Display options for Valid, Invalid, Ignored, and All Data

  • Online and Offline Load process

  • Query option for Historical Loads

  • Historical Loads Export to Excel

  • Drill back to source from the Workbench

  • Load, check and post journals for Oracle Hyperion Financial Management applications

Note:

When you log in with the Run Integration role, these links are visible in the Tasks pane: Data Load Workbench, Data Load, Member Mapping, HR Data Load, Metadata, and Process Detail.

The Data Load Workbench consists of four sections: