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
Converts an aggregate storage option (ASO) export file in its native format to a tabular comma-separated values (CSV) file
Inputs
| Input | 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
Converts a tabular CSV file to conform to the native Essbase format
Inputs
| Input | 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 the CSV Data input contains a header row, check this box |
| Data Set Delimiter | Select the delimiter used in the CSV Data input |
| 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 the CSV Data input that represents Note: The command converts all null values to
|
Outputs
| Output | Output Type |
|---|---|
| Converted Native Format | File |
| Line Count | Integer |
Exit Codes
| Code | Type | Detail |
|---|---|---|
| 0 | Success | Success |
| 1 | Error | General failure |