Data Export Target Application Options

The following options are available when defining the target application options for a data export to file application:

Option Description
Download File Name

You can specify your own file name when generating a data export output file as part of a data export to file integration definition, for example, ddmexport.csv.

When a user-defined name is specified, the system creates two output files:

  • the first output file is assigned the target application name and job id and it is saved to the Data Integration outbox, for example, /u03/inbox/outbox.

  • The second output file is assigned the user-defined file name and it is saved to the platform inbox/outbox, for example, /u03/lcm. (The inbox and outbox locations may differ across Oracle Fusion Cloud EPM business processes.)

    By design, the output file with the user-defined name enables users to download the output file using EPM Automate. For more information, see Export and Download Metadata and Data.

Column Delimited

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

Available column delimiters are:

  • ,

  • |

  • !

  • ;

  • :

The default delimiter is a comma (,).

The tab delimiter for columns in a data export to file target application is not available.

Note:

If a source application contains members with a comma, you can use a different delimiter (excluding the TAB delimiter) in the import format definition to process the export. For more information, see Creating the Dimension Maps.

The output file is created using the column delimiter option value defined in Data Exchange Target Application Options.

Decimal Separator

Specify the symbol used to mark the border between the integer and the fractional parts of a decimal number.

Available options:

  • Decimal Comma
  • Decimal Point

The decimal point (.) is typically used in the United States and other English-speaking countries. The decimal comma (,) is typically used in continental Europe and several Arabic-speaking countries.

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

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

For Oracle Fusion Cloud Enterprise Performance Management, Data Integration 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 setting minimizes 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.

Applicable for numeric import formats only. It is not supported for nun-numeric import format types.

When the Pivot Dimension is specified, Accumulate Data is forced to "Yes."

The pivoted columns for the values contained in the Pivot dimension needs to be enclosed in ~~ within the SQL Insert statement.

The Pivot feature works only when using a custom SQL Insert statement and does not work without the SQL Insert statement.

When the Data Export application contains ACCOUNT, PERIOD & AMOUNT as dimension names, by specifying PERIOD as Pivot Dimension, all the periods contained in the PERIOD dimension are pivoted to a separate column Jan, Feb, Mar etc.

For example, the SQL INSERT statement is:

INSERT INTO TABLE (ACCOUNT,JAN,FEB,MAR,……,DEC) VALUES (~ACCOUNT~,~Jan~,~Feb~,~Mar~,,,,,,,,~Dec~)