importDimension
Imports a dimension from a file into an Oracle Enterprise Data Management Cloud application.
This command can import an input file from a connection defined in Oracle Enterprise Data Management Cloud or the staging area.
If the file is to be imported from the Oracle Enterprise Data Management Cloud staging area, a Service Administrator uses the uploadFile
command to upload it
into the target Oracle Enterprise Data Management Cloud
environment. A Service Administrator may also use the
copyFileFromInstance
command to
copy the file from another Oracle Enterprise Performance Management Cloud
environment.
Applies to
Oracle Enterprise Data Management Cloud.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 Oracle Enterprise Data Management Cloud 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 Oracle Enterprise Data Management Cloud 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 EPM Cloud environment:
epmautomate importDimension USOperations Entity ReplaceNodes data_Entity.ZIP Connection=EPM_Cloud_pln