The Import/Export Facility is a standalone application that writes directly to the Performance Scorecard database. It enables you to share data between Performance Scorecard and comma-separated value (CSV) text files by performing these tasks:
Exporting data from aPerformance Scorecard application to a CSV file
Importing data from a CSV file to Performance Scorecard applications
You can combine these operations to extract data from Performance Scorecard, modify them, then re-import the modified data in one operation using a scheduling program. You can also use Microsoft Excel spreadsheets to create a data file which can update, add, or delete data in Performance Scorecard, or export existing data from Performance Scorecard for use in another environment. This enables you to extract all computed values such as targets, results, scores and status and trend information.
Imported is added to applications after 150 seconds. You need not restart the application server. Invoke the facility from the command line using an import or export command. Each command uses the same line syntax. Specify the behavior to use and a data file in the command. The behavior defines the type of data to import or export. The data file is the name of the file that contains or will contain the data.
Install the Import/Export facility with Performance Scorecard as described in the Oracle Hyperion Enterprise Performance Management Installation and Configuration Guide.