To communicate with Oracle® Enterprise Performance Management (EPM) as part of a chain, add a step that includes an Oracle EPM Utilities connection command.
Note: To enable these commands, an IT admin first creates an Oracle EPM connection.
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 |