Step 3: Exporting Data to Target Applications

After the source data has passed the validation process, use the Export option to export data to a target application. Select this option after you have reviewed the data in the data grid and are sure you want to export it to the target application.

When exporting data for Oracle Hyperion Planning and Oracle Essbase, you can store, add, and subtract data. For Planning and Essbase, you can override all data.

For Oracle Hyperion Financial Management, you can merge, accumulate, replace, and replace by security data.

When you use Oracle Hyperion Enterprise Performance Management System Lifecycle Management to export mapping rules, any related mapping scripts are included.

The export of mapping rules to a CSV or Excel format does not include any scripting.

To submit the data load rule:

1. On the Workflow tab, under Data Load, select Data Load Workbench.
2. Optional: When you import a source file, Oracle Hyperion Financial Data Quality Management, Enterprise Edition uses the current POV to determine location, category, and period and conducts the following process: To import another source file, you must change the POV. See Using the POV Bar.
3. At the top of the screen, click Export.
4. In Execution Mode drop-down, select the mode for exporting the source data to the target application.

   • online—ODI processes the data in sync mode (immediate processing).

   • offline—ODI processes the data in async mode (runs in background).

     Click to navigate to the Process Detail page to monitor the ODI job progress.

5. Click OK.