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, you must use the
command to upload it into the target Oracle Enterprise Data Management Cloud environment. You may also use the
command to copy the file from another Oracle Enterprise Performance Management Cloud environment.
Applies toOracle Enterprise Data Management Cloud.
Required RolesService Administrator, User (with Data Manager permission)
epmautomate importDimension APPLICATION DIMENSION IMPORT_TYPE FILE_NAME [connection=NAME]where:
APPLICATIONis the name of an Oracle Enterprise Data Management Cloud application
DIMENSIONis the name of the application dimension being imported
IMPORT_TYPEindicates how to perform the import. Valid import types are:
ResetDimensionto delete all existing dimension data and import the new data
ReplaceNodesto add or update nodes and replace existing hierarchies during import
Mergeto process incremental changes to the nodes and hierarchies using an import request
FILE_NAMEis 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
connectionis specified, you must import dimension from a a ZIP file; for example,
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.
- 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