7 Data Validation

Overview

Oracle Fusion Analytics Warehouse provides library of metrics to validate data between your Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance.

You can 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. 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.

SCM Metrics Spreadsheet

Use this spreadsheet that contains library of SCM metrics that are supported in Oracle Fusion Analytics Warehouse.

Procurement Metrics Spreadsheet

Use this spreadsheet that contains library of Procurement metrics that are supported in Oracle Fusion Analytics Warehouse.