Data Validation

Description

As a functional administrator, you can validate a library of metrics between your instance and the Oracle Transactional Business Intelligence instance. The library of metrics is part of . 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, 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.

Business Questions

This subject area can answer the following business questions:

• Did my data get loaded into Oracle Autonomous Data Warehouse accurately?
• Can I schedule a regular data validation on a periodic basis?
• If there is a variance between my Oracle Transactional Business Intelligence source and destination data, then how can I pinpoint which data is different?
• Are there built-in metrics for this data validation?
• Can I create my own (custom) metrics for specific data to validate?

Duty Roles

The System Administration duty role secures access to this subject area. See Common Duty Roles.

Primary Navigation

Data Validation tile under Application Administration on the Console

Folder: /Shared Folders/Common/Data Validation

Special Considerations

None.