Validate Your Data
As a functional administrator, validate the data after loading the source data in to your data warehouse.
You can schedule the validation of your data using the ready-to-use validation sets or custom validation sets that you create. You can create a validation set and define the subject area, metrics, and columns that you want to validate and schedule the validation frequency and date. You see the validation sets that you create under Custom Validation Sets in the Scheduled Validation tab.
Ensure that you validate data from the initial extract date set up in the pipeline settings and avoid using any data before the initial extract date. For example, if the Initial Extract Date in the pipeline settings is January 1, 2014, even if there is data in your Oracle Fusion Cloud Applications source from January 1, 2010 to December 31, 2013, since there is nothing to validate it against in the warehouse, the data validation process won't produce correct results.
Based on the schedule and the validation set, Oracle Fusion Analytics Warehouse validates the data and stores the details in the Data Validation workbook available in the Common folder in Oracle Analytics Cloud. Use the report tabs such as Validate data for ERP Analytics and Validate data for HCM Analytics available in this workbook to view the data validation details.
- In Oracle Fusion
Analytics Warehouse
Console, click Data Validation
under Application Administration.
- On the Data Validation page, in the Scheduled Validation tab, ensure that the Run automated Data Validation Reports toggle is “on” if you want to validate your data using the ready-to-use validation sets or your custom validation sets. Select the check box for the specific validation sets.
- To create a custom validation set, click Create New Report.
- In Create Validation Set:
- 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.
