loadDimensionViewpoint

Loads data into one unbound, bound, or partially bound viewpoint (a subset of nodes) from a load file using a defined load.

The load file, a CSV, Excel (XLSX) file or a ZIP file containing one CSV or XLSX file, must be available in the environment where you are loading the viewpoint. You can upload the load file to the environment using the uploadFile or copyFileFromInstance command.

To load a viewpoint using the default load definition, use the loadViewpoint command.

Applies to

Oracle Fusion Cloud Enterprise Data Management.

Required Roles

Service Administrator

Usage

epmautomate loadDimensionViewpoint APPLICATION_NAME DIMENSION_NAME FILE_NAME LOAD_NAME [loadOption=ReplaceNodes|Merge] [purpose="PURPOSE"], where:
  • APPLICATION_NAME is the name of an Cloud EDM application.
  • DIMENSION_NAME is the name of the dimension that you want to load.
  • FILE_NAME is the name of the file (including extension: CSV, XLSX or a ZIP) from which the viewpoint is to be loaded.
  • LOAD_NAME is the name of the defined load that is to be used for loading the viewpoint.
  • loadOption, optionally, identifies how to load the viewpoint. Valid load options are:
    • ReplaceNodes to clear all relationships (including orphan relationships and those used by other viewpoints using the same hierarchy set) from the hierarchy other than those from the load file. This is the default load type.
    • Merge to preserve existing relationships by processing only incremental changes.
  • purpose, optionally, is a text string, enclosed in double quotation marks, identifying the reason for loading the viewpoint.

Examples

  • Load viewpoint replacing existing hierarchies: epmautomate loadDimensionViewPoint "Data Warehouse" Citizen Data_Warehouse_Citizen_20241108.csv DW-Citizen
  • Load viewpoint by merging incremental changes with the specified load: epmautomate loadDimensionViewPoint"Data Warehouse" Citizen Data_Warehouse_Citizen_20241108.csv DW-Citizen loadOption=Merge purpose="Load Test"