1. Administering Data Integration for Oracle Enterprise Performance Management Cloud
  2. Reviewing Process Details and Viewing Results in the Workbench
  3. Using the Workbench
  4. Using the Workbench Workflow
  5. Validating Source Data

Validating Source Data

Validating the source data confirms that all members are mapped to a valid target system account. It also compares the dimension mapping to the source file and identifies unmapped dimensions. The workflow cannot continue until all dimensions are properly mapped, and any validation error are corrected.

To validate source data:

  1. From the Data Integration home page, click Image shows Select icon. to the right of the integration, and then select Workbench.
  2. Optional: Click Period, to select another period from the current POV.
  3. Click Validate (Image shows Validate icon.).

    The validation is submitted for execution. When the process has been executed and the validation fails, the message: "Status Message: Failed" is displayed and the Validate icon is shown in grey. If the validation is successful, the Validate icon is shown in blue.

    Note:

    If you rerun validations in the Workbench, the system won’t pick up expressions, just mapping rules.

  4. Optional: To run the validation offline, click Continue Offline.
  5. Optional: Click Image shows the Output File icon. to download the log, and then open it.