Exports a dimension from an Oracle Enterprise Data Management Cloud application to a file in the staging area or, optionally, to a target environment defined in a connection.
Applies toOracle Enterprise Data Management Cloud
Required RolesService Administrator, User (with Data Manager permission)
epmautomate exportDimension APPLICATION DIMENSION FILE_NAME [connection=NAME] where:
APPLICATIONis the name of an Oracle Enterprise Data Management Cloud application
DIMENSIONis the name of an application dimension
FILE_NAMEis the name of the file (CSV for export to a file or ZIP for export to Oracle Financials Cloud) for storing the exported 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
downloadFilecommand or copy it to another Oracle Enterprise Performance Management Cloud environment using the
connection=NAME, optionally, identifies a connection name (instance location) defined in Oracle Enterprise Data Management Cloud. If specified, the export file is uploaded to the target environment (inbox for EPM Cloud and default upload location for Oracle Financials Cloud).
Note:The credentials specified in the connection definition must have the access rights to write to the target environment.
- Export to Oracle Enterprise Data Management Cloud staging area:
epmautomate exportDimension USOperations Entity EntityData.CSV
- Export and upload to Oracle Financials Cloud:
epmautomate exportDimension USOperations Entity EntityData.zip Connection=ora_fusion_gl
- Export and upload to target EPM Cloud inbox:
epmautomate exportDimension USOperations Entity EntityData.CSV Connection=EPM_cloud_pln