Help Desk

Submit a ticket My Tickets
Welcome
Login

Oracle EPM Utilities Command Reference

Various tools a utilities for working with the Oracle EPM suite and other Oracle applications

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

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
B
Brian is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.