1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Defining a Data Integration
  3. Setting Data Integration Options
  4. Defining Target Options
  5. Data Export Target Application Options

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

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 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.
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 EPM Cloud, 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~)