Table of Contents

Connections

Commands

Connections

Oracle EPM Utils

The connector for the Oracle EPM Utils. There is no authentication or parameters necessary.

Inputs

None

Commands

Convert ASO to Tabular

Converts an ASO export file in native format to a tabular file

Inputs

Input

Type

Detail

Notes

ASO Export File

FileField

ASO Export file in tabular format

LCM Export File

FileField

The application's LCM Export zip file. Note: You'll only need to export the metadata of your application, as this file is used to determine the dimensions and members of your application

Format for Oracle PCMCS

BooleanField

This option will provide additional formatting necessary for Oracle PCMCS. Check this if you will be using the converted data with Oracle PCMCS.

Add Headers to the CSV File

ArrayField

When specified, the provided headers will be the first row in the created tabular file.

Outputs

Output

Output Type

Notes

CSV Output File

File

Exit Codes

Code

Type

Detail

0

Success

Command succeeded

1

Error

General Failure

Convert CSV to Native Essbase Format

Converts a CSV (Tabular) file to conform to the Essbase Native Format

Inputs

Input

Type

Detail

Notes

Preview Result

BooleanField

Whether or not to preview the result

CSV Data

FileField

The tabular data set to convert.

Has Header Row

BooleanField

Whether or not the data being converted contains a header row

Data Set Delimiter

DropdownField

The delimiter of CSV the data set that is being converted

Values Start Column

NumberField

The first column that contains numeric data. If left blank the command with try to auto-detect the column.

Null Data Representation

TextField

The value in the source tabular data set that represents NULL. All data values that contain this value will be converted to: #Mi

Omit Header

BooleanField

When selected, the output file will not contain a header row

Outputs

Output

Output Type

Notes

Converted Native Format

File

Line Count

Integer

Exit Codes

Code

Type

Detail

0

Success

Command succeeded

1

Error

General Failure

Did this answer your question?