Validate the data after loading the source data in to your data warehouse.
Sign in to your service.
In Oracle Fusion
Analytics Warehouse, open the Navigator menu, click Console, and then click Data Validation under Application Administration.
You see the Data Validation page.
On the Data Validation page, in the Detailed Validation tab, select the subject area such as Financials - GL Balance Sheet, a metric related to the selected subject area, and the column set that you want to validate.
You see the columns listed from the selected Column Set.
For each column, click the + icon to open the Select Values dialog.
In Select Values, 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.
Click Select to retain the selection.
In the Detailed Validation tab, click Run to show the metric values in the Oracle Fusion
Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance.
On the Data Validation page, click Show Summary to display the detail drill down of the metric values for Oracle Fusion
Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance.
Select the attribute columns that you would like to pivot the details on in the display.
You see the Summary table with 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
On the Data Validation page, click Show Details to show the detail drill down of the metric values for the Oracle Fusion
Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance. The detail table gives the actual data for the differences between these instances using the pivot columns that you had selected previously.
Optional: Use the Download Details option to download the detail data into a csv file.
Optional: Use the Change Columns option to change the columns that you would like to pivot the detail data on.
This regenerates the summary and the detail analysis.