Use the Export to Target feature to export data to a target application, which is the Enterprise Resource Planning (ERP) application. Select this option after you have reviewed the data in the data grid and need to export it to the target application.
Export options:
When exporting data for Essbase, you can store, add, and subtract data.
When exporting data for Planning, the following options are available:
Store Data—Inserts the data from the source or file into the target application, replacing any value that currently exists.
Add Data—Adds the value from the source or file to the value in the target application. For example, when you have 100 in the source, and 200 in the target, then the result is 300.
Subtract Data—Subtracts the value in the source or file from the value in the target application. For example, when you have 300 in the target, and 100 in the source, then the result is 200.
Override All Data—Clears all data in the target, and then loads from the source or file. For example, when you have a year of data in your Planning application but are only loading a single month, this option clears the entire year before performing the load.
To submit the data load rule:
From the table action bar, in Data Rule, and choose the data load rule.
In Execution Mode, select the mode of exporting to the target.
Execution modes:
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.
In Export, select the export method.
Export options:
For Current Dimension and All Dimensions export methods, in Select file location, navigate to the file to export, and then click OK.
For the Export to Excel method, mappings are exported to a Microsoft Excel spreadsheet.
After you exported data to the target, the status of the export is shown in the Status field for the data load rule in the Data Load Summary.
.