As a functional 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.
To validate data between the source and warehouse, the Oracle Fusion Analytics Warehouse functional administrator and Oracle Fusion Cloud Applications user must have the same privileges. For example, if you're an administrator in Oracle Fusion Analytics Warehouse and Oracle Fusion Cloud Applications, then you can use those user IDs to perform data validation.
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 in Oracle Fusion Analytics Warehouse to access the Common folder in Oracle Analytics Cloud and to view the output of the data validation project.
- Create a user, such as
MyFAWValidationUser, to validate the extracted data. See Create a User to Validate the Extracted Data.
- Create a custom BI Abstract role and associate it with an applicable user, such as
MyFAWValidationUser, whose credentials you want to provide for data validation.
- In Oracle Fusion
Analytics Warehouse, on the Source Credentials tab of the Data Validation page, provide the
credentials of the applicable user, such as
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.