To communicate with Oracle® Enterprise Performance Management (EPM) as part of a chain, add a step that includes an Oracle EPM Utilities connection command.
To enable these commands, an IT admin first creates an Oracle EPM Utils connector.
Convert ASO to tabular
To convert an aggregate storage option (ASO) export file in its native format to a tabular comma-separated values (CSV) file, use a Convert ASO to tabular command.
Properties
Property |
Detail |
ASO export file |
Enter the ASO export file in its native format. |
LCM export file |
Enter the application's life cycle management (LCM) export ZIP file.
Note: Since the command uses this file to determine the dimensions and members of your application, this input requires only your application's metadata.
|
Format for Oracle PCMCS |
If using the converted tabular file with Oracle Profitability and Cost Management Cloud Service (PCMCS), check this box to provide the additional necessary formatting. |
Add headers to CSV file |
To add a header row to the output CSV, enter an array of the headers to include. |
Outputs
Output |
Output type |
CSV output file |
File |
Exit codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
General failure |
Convert CSV to native Essbase format
To convert a tabular CSV file to conform to the native Essbase format, use a Convert CSV to native Essbase format command.
Properties
Property |
Detail |
Preview result |
To preview the resulting native Essbase format, check this box. |
CSV data |
Enter the tabular CSV file to convert. |
Has header row |
If CSV data contains a header row, check this box. |
Data set delimiter |
Select the delimiter used in CSV data. |
Values start column |
Enter the number of the first column that contains numeric data. To automatically detect the column, leave blank. |
Null data representation |
Enter the value in CSV data that represents NULL .
Note: The command converts all null values to #Mi .
|
Omit header |
Select whether to omit a header row in the output file, such as if CSV data has a single row of data and the header is unnecessary. |
Outputs
Output |
Output type |
Converted native format |
File |
Line count |
Integer |
Exit codes
Code |
Type |
Detail |
0 |
Success |
Success |
1 |
Error |
General failure |