1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Using Data Management
  3. Administration Tasks
  4. Registering Target Applications
  5. Creating a Data Export File
  6. Data Export to File Properties

Data Export to File Properties

Use the following options when defining the data export to file application:

Filter Description
Download File Name

Enter the name of the output file.

You can use EPM Automate to download the output file. The EPM Automate Utility enables Service Administrators to remotely perform Oracle Enterprise Performance Management Cloud tasks.

For more information, see Working with EPM Automate for Oracle Enterprise Performance Management Cloud.

Column Delimited

Select the character to use for delimiting columns in the output file.

Available column delimiters are:

  • ,

  • |

  • !

  • ;

  • :

The default delimiter is a comma (,).
Workflow Mode

Select the data workflow method.

Available options:

  • Full—Data is processed in the TDATASEG_T table and then copied to the TDATASEG table.

    All four Workbench processes are supported (Import, Validate, Export, and Check) and data can be viewed in the Workbench.

    Drill-down is supported.

  • Full No Archive—Data is processed in the TDATASEG_T table and then copied to TDATASEG table.

    All four Workbench processes are supported (Import, Validate, Export, and Check). Data can be viewed in the Workbench but only after the import step has been completed. Data is deleted from TDATASEG at the end of the workflow process.

    Drill-down is not supported

  • Simple— Data is processed in the TDATASEG_T table and then exported directly from the TDATASEG_T. table.

    All data loads include both the import and export steps.

    Data is not validated and any unmapped data result in load failure.

    Maps are not archived in TDATAMAPSEG.

    Data cannot be viewed in the Workbench.

    Drill-down is not supported.

    The Simple Workflow Mode is the default mode.
File Character Set

Specify the file character set.

The file character set determines the method for mapping bit combinations to characters for creating, storing, and displaying text. Each encoding has a name; for example, UTF-8.

UTF-8 is the default file character set.
End of Line Character

Select the operating system of the server associated with the End Of Line (EOL) character.

Valid options are

  • Windows
  • Linux

indicates end of line. Some text editors like Notepad will not display files using Linux EOL correctly.

An EOL character indicates the end of line. Some text editors like Notepad do no display files using the Linux EOL correctly.

For EPM Cloud, Data Management uses the Linux EOL character as the defaults.

When customers views exported files in Windows, the EOL shows on a single line.
Include Header

Determines whether to include/exclude the header record in the output file.

Select Yes to include the dimension name in the header record. The default is Yes.

Select No to exclude the header record.

Export Attribute Columns

Include attribute columns if you have some static values to include in the export or file. You can also use attribute columns if you don't have a requirement to map the source values. This will minimize the need to define data load mapping.

Select Yes to include attribute columns.

Select No to exclude attribute columns.

Accumulate Data

Summarizes Account data before export and groups the results by one or more column.

Select Yes to group the results by one or more columns.

Select No to not group the results by one or more columns.

The default value is Yes.

Sort Data

Determine if data is sorted based on the column order or not.

Select Yes to include columns.

Select No to exclude columns.

Pivot Dimension

Pivoting changes the orientation of the data in the export file enabling you to aggregate the results and rotate rows into columns. When you pivot between rows and columns, the system moves the selected dimension to the outermost row or column on the opposite axis.

To use this feature, specify one dimension name from the export file.