7 Data Validation

Overview

Oracle Fusion Data Intelligenceprovides library of metrics to validate data between your Oracle Fusion Data Intelligence 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 prebuilt 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 Data Intelligence validates the data and stores the details in the Data Validation workbook available in the Common folder in Oracle Analytics Cloud.

Finance Metrics Spreadsheet

Use this spreadsheet that contains library of Finance metrics that are supported in Oracle Fusion Data Intelligence.

Project Metrics Spreadsheet

Use this spreadsheet that contains library of Project metrics that are supported in Oracle Fusion Data Intelligence.

Procurement Metrics Spreadsheet

Use this spreadsheet that contains library of Procurement metrics that are supported in Oracle Fusion Data Intelligence.