importDimension
Imports a dimension from a file into an Oracle Fusion Cloud Enterprise Data Management application.
This command can import an input file from a connection defined in Cloud EDM or the staging area.
If the file is to be imported from the Cloud EDM staging area, a Service Administrator uses the uploadFile
command to upload it
into the target Cloud EDM
environment. A Service Administrator may also use the
copyFileFromInstance
command to
copy the file from another Oracle Fusion Cloud Enterprise Performance Management
environment.
Applies to
Cloud EDM.Required Roles
- Service Administrator
- User (with Data Manager permission)
Usage
epmautomate importDimension APPLICATION DIMENSION IMPORT_TYPE FILE_NAME [connection=NAME]
where:
APPLICATION
is the name of an Cloud EDM applicationDIMENSION
is the name of the application dimension being importedIMPORT_TYPE
indicates how to perform the import. Valid import types are:ResetDimension
to delete all existing dimension data and import the new dataReplaceNodes
to add or update nodes and replace existing hierarchies during importMerge
to process incremental changes to the nodes and hierarchies using an import request
FILE_NAME
is the name of the file (CSV or ZIP) containing the dimension data to be imported. The file name must end with the dimension name prefixed with _ (underscore character); for example,import_Entity.csv
. If you are importing from a ZIP file containing multiple import files, this command depends on the file name within the ZIP file to identify the right import file.If a value for
connection
is specified, you must import dimension from a a ZIP file; for example,importdata_Entity.zip
.connection=NAME
, optionally, identifies a connection name (instance location) defined in Cloud EDM as the location of the import file. If not specified, the import process will look in the local staging area for the import file.
Examples
- Import from a file uploaded to the staging area:
epmautomate importDimension USOperations Entity ReplaceNodes data_Entity.CSV
- Import from the outbox of another Cloud EPM
environment:
epmautomate importDimension USOperations Entity ReplaceNodes data_Entity.ZIP Connection=Cloud-EPM_pln