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 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 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