extractDimension

Extracts an Oracle Enterprise Data Management Cloud dimension to a file or to a global connection.

Applies to

Oracle Enterprise Data Management Cloud

Required Roles

Service Administrator, User (with Data Manager permission)

Usage

epmautomate extractDimension APPLICATION DIMENSION EXTRACT_PROFILE FILE_NAME [connection=NAME] where:

• APPLICATION is the name of an Oracle Enterprise Data Management Cloud application.
• DIMENSION is the name of the dimension to be extracted.
• EXTRACT_PROFILE is the name of an extract profile defined in the application. This profile is used to extract the dimension.
• FILE_NAME is the name of a file (CSV for export to a file or ZIP for export to Oracle Financials Cloud) for storing the extracted data. If the connection parameter value is not set, this file is created in the staging area. You can download it to a local computer using the downloadFile command or copy it to another Oracle Enterprise Data Management Cloud environment using the copyFileFromInstance command.
• connection=NAME optionally, identifies a global connection name (instance location) defined in Oracle Enterprise Data Management Cloud as the location of the file. If specified, the extract file is uploaded to the target environment (inbox for Oracle Enterprise Performance Management Cloud and the specified document account for Oracle ERP).

  Note:

  The credentials specified in the global connection must have access rights to write to the target environment.

Examples

• Extract to Oracle Enterprise Data Management Cloud staging area: epmautomate extractDimension USOperations Entity EntityExtProfile EntityData.CSV
• Extract and upload to Oracle ERP: epmautomate extractDimension USOperations Entity EntityExtProfile EntityData.zip Connection=ora_fusion_gl
• Extract and upload to target EPM Cloud inbox: epmautomate extractDimension USOperations Entity EntityExtProfile EntityData.CSV Connection=EPM_cloud_pln