Exporting Data

You export data from the Applications page.

As an alternative, you can export data using Data Integration. See Administering Data Integration for Oracle Enterprise Performance Management Cloud.

To export data:

1. On the Home page, click Application.
2. Click Overview, and from Actions, select Export Data.
3. Click Create.
4. On the Export Data page, select the target location of the data export file:

   • Local—Saves the data export file to a location on your local computer.

   • Outbox—Saves the data export file to the server.

5. For Cube Type, select either Consol or Rates.
6. For File Type, select an option:

   • Comma delimited—Creates a comma-delimited .csv file for each artifact.

   • Tab delimited—Creates a tab-delimited .txt file for each artifact.

   • Other—Creates a .txt file for each artifact. Enter the delimiter character that you want to use in the export file. For a list of supported delimiter characters and exceptions, see Other Supported Delimiter Characters.

7. For Smart Lists, specify Export Labels or Export Names.
8. For Dynamic Members, select whether to Include or Exclude dense dynamic calculation members during export.

   Note the following:

   • Excluding dynamic calculation members from exported data improves performance during data exports.

   • Sparse dynamic members are not included in the export even if the Include option is selected.

9. Under Slice Definition, select the Row, Column and Point of View for the slice of data to be exported.

   If the Application supports Period and Movement as Dense, then either Period or Movement must be in the Column. Otherwise, if Account is the only dense dimension in the system, then Account must be in the Column.

10. Select the action to export the data:
    • If the selected location is Outbox, click Save as Job to save the export operation as a job, which you can schedule to run immediately or at a later time.
    • If the selected location is Local, click Export, and then specify where to save the data export file.

    To reduce the size of data export file, if a form has an entire row of #missing values, the row will be omitted from the data export file.