4 Validate Oracle Fusion Analytics Warehouse Data

As the cloud account administrator with the Functional Administrator or System Administrator application role, you validate the data after loading the source data from Oracle Applications Cloud into your data warehouse.

About Validating Your Data

As an administrator, you can validate a library of metrics between your Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance. The library of metrics is part of Oracle Fusion Analytics Warehouse.

Prerequisites for Data Validation

Here's a list of prerequisites for validating your data as an administrator:

  • Ensure that you can access the Oracle Transactional Business Intelligence instance and run queries.
  • Ensure that you have the same data security privileges in Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance.
  • Create a custom BI Abstract role and associate it with the FAWService user.

Create a Custom BI Abstract Role

You create a BI Abstract role and associate it with the FAWService user.

Use the Security Console of Oracle Applications Cloud. See Create Roles in the Security Console
  1. Sign in to Oracle Applications Cloud with your administrator credentials.
  2. Navigate to Tools and then to Security Console.
  3. In the Security Console, select the Roles tab, and then click Create Role.
  4. In the Create Roles wizard, on the Basic Information page, enter a role name such as FAW Custom Data Validation Role and a role code such as FAW_CUSTOM_DATA_VALIDATION_ROLE, and select BI - Abstract Roles as role category.
  5. In the Create Roles wizard, on the Role Hierarchy page, add the BI Impersonator role as a member of the newly created BI Abstract role.
  6. In the Create Roles wizard, on the Users page, add the FAWService user to the newly created BI Abstract role.
  7. In the Create Roles wizard, on the Summary page, verify the details, save, and then close the wizard.

Validate Your Data

Validate the data after loading the source data in to your data warehouse.

  1. Sign in to your service.
  2. In Oracle Fusion Analytics Warehouse, open the Application Navigation menu, click Console, and then click Data Validation.
    You see the Data Validation page.
  3. On the Data Validation page, select the subject area such as Financials - GL Balance Sheet, a metric related to the selected subject area, and the validation context that you want to validate.
    You see the Required Parameter section. You see the Optional Parameter section too, if optional parameters are defined for the selected metric.
  4. In Required Parameter, for each parameter, click the magnifying lens icon to open the Parameter Value Selection dialog.
  5. In Parameter Value Selection, select the values that are displayed, or search for values, or click Show More Values, and then move them to the Selected Values box using the arrows.
  6. Click Select to retain the selection.
  7. On the Data Validation page, click Run to show the metric values in the Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance.
  8. On the Data Validation page, click Show Details to display the detail drill down of the metric values for Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance.
    You see these tables:
    • Summary table: This table provides the values for these categories:
      • Total Records in Analytics Warehouse
      • Total Records in Oracle Transactional Business Intelligence
      • Records Only in Analytics Warehouse
      • Records Only in Oracle Transactional Business Intelligence
      • Matched Records
      • Mismatched Records
    • Details table: This table gives the actual data for the differences between the Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance. The data in this table is shown only if there are any differences between the two instances.