1. Administering Data Management for Oracle Enterprise Performance Management Cloud
  2. Integration Tasks
  3. Loading Data
  4. Using Excel Trial Balance Files to Import Data
  5. Importing Excel Mapping

Importing Excel Mapping

You can import Excel mappings by selecting the Import option and selecting an Excel mapping.

Note:

The import of mapping rules using an Excel template provides a place to specify a mapping script.

To import an Excel mapping:

  1. On the Workflow tab, under Data Load, select Data Load Mapping.
  2. Select the All Mapping tab.
  3. From the Import drop-down, select Import from Excel.
  4. From Select a file to import, select the Excel file to import, and then click OK.
  5. From Select mode and validation, in Import mode, select the import mode.

    Image shows Select import mode and validation screen

    • Merge—Overwrites the data in the application with the data in the Excel data load file.

    • Replace-Clears values from dimensions in the Excel data load file and replaces them with values in the existing file.

  6. Click Validate to validate the mappings.
  7. Click OK.

    The mapping inherits the default data load rule and shows the description: "System Generated Mappings."