Exporting Metadata

You can export metadata to a flat file in a .csv (comma-delimited) or .txt (tab-delimited or other delimiter character) format.

These artifacts are supported in an export:

Enterprise Profitability and Cost Management creates an export file for each artifact (.txt or .csv, depending on the file type), and all export files are consolidated into one zip file. You must extract the .csv or .txt files from the zip file if you want to use the files as import files (for example, when importing into another application).

Note:

Only characters that are included in the UTF-8 character set are supported in export or import files. Characters that aren't included in the UTF-8 character set are considered invalid. For dimension name restrictions, see Naming Restrictions for Dimensions, Members, and Aliases.

To export metadata to a flat file:

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

  2. On the Application page, select the Dimensions tab, and then click Export.

  3. On the Export Metadata page, click Create.

  4. Select the target environment of the export file:

    Note:

    • 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.

  5. Select the artifact or artifacts to export.

  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. Optional: If the location selected is Outbox, click Save as Job to save the export operation as a job, which you can schedule to run right away or at a later time. See Managing Jobs.

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