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, you must use the uploadFile command to upload it into the target Oracle Enterprise Data Management Cloud environment. You 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 application
  • DIMENSION is the name of the application dimension being imported
  • IMPORT_TYPE indicates how to perform the import. Valid import types are:
    • ResetDimension to delete all existing dimension data and import the new data
    • ReplaceNodes to add or update nodes and replace existing hierarchies during import
    • Merge 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