extractDimension

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

Applies to

Cloud EDM

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 Cloud EDM 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 Cloud EDM environment using the copyFileFromInstance command.
• connection=NAME optionally, identifies a global connection name (instance location) defined in Cloud EDM as the location of the file. If specified, the extract file is uploaded to the target environment (inbox for Oracle Fusion Cloud Enterprise Performance Management 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 Cloud EDM 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 Cloud EPM inbox: epmautomate extractDimension USOperations Entity EntityExtProfile EntityData.CSV Connection=EPM_cloud_pln