About Validating Your Data
As an administrator, you can validate a library of metrics between your Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance. The library of metrics is part of Oracle Fusion Analytics Warehouse.
Prerequisites for Data Validation
Here's a list of prerequisites for validating your data as an administrator:
- Ensure that you can access the Oracle Transactional Business Intelligence instance and run queries.
- Ensure that you have the same data security privileges in Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance.
- Ensure that you’re assigned the Integration Specialist Group to access the Common folder in Oracle Analytics Cloud and to view the output of the data validation project.
- Create a custom BI Abstract role and associate it with the FAWService user.
- In Oracle Fusion
Analytics Warehouse, on the Source Credentials tab of the Data Validation page, provide and confirm
your password for the FAWService user.
Note:
If the password has expired, then set the new password using the Source Credentials tab. To navigate to the Source Credentials tab, open the Navigator menu, click Console, and then click Data Validation under Application Administration. You see the Scheduled Validation, Detailed Validation, and Source Credentials tabs.
