1. Administering and Working with Enterprise Profitability and Cost Management
  2. Creating and Managing Applications
  3. Managing Applications
  4. Importing and Exporting Data
  5. Exporting Data

Exporting Data

To export data to a file:

  1. From the Home page, select Application, and then select Overview.

  2. On the Application page, select Actions, and then Export Data.

  3. On the Export Data page, click Create.

  4. For Location, select the target environment of the data export file:

  5. Select the cube.

  6. Select the file type:

    • 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 dynamic calculation members during export.

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

  9. For Decimals, specify the number of decimal positions (0-16) to format the data after export, or select None to use the default precision formatting.

    For example, specifying a decimal value of 3 in the Decimals field results in the exported data displaying three digits to the right of the decimal point, wherever applicable.

    Selecting None formats the decimal number as specified in the default precision settings, whereas selecting 0 formats the data to display a whole number. For example, if the data value you are exporting is 123.45678, selecting 0 exports the data as 123, and selecting None exports the data as 123.45678.

  10. For Slice Definition, select the slice of data to export.

    If you are exporting data for multiple members simultaneously, make sure that at least one of the members you select is a non-shared member. You can export shared members individually because it's equivalent to selecting a base member. However, selecting level 0 descendants of a parent member whose descendants are all shared members is equivalent to not selecting any members from a dimension and the export will not run. Therefore, you must ensure that one of the members selected is a non-shared member.

  11. Optional: If you selected Outbox as the location of the export data file, click Save as Job to save the export operation as a job, which you can run immediately or schedule to run at a later time.

    • You can run up to five export jobs at one time.
    • When scheduling export jobs, you can specify a unique output file name for each job.
    • For more information about scheduling jobs, see Managing Jobs.

  12. Click Export, and then specify where to save the data export file.

Note:

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