Validate Oracle Analytics for Applications Data
As the cloud account administrator with the Functional Administrator or System Administrator application role, you validate the data after loading the source data from Oracle Applications Cloud in to your data warehouse.
About Validating Your Data
As an administrator, you can validate a library of metrics between your Oracle Analytics for Applications instance and the Oracle Transactional Business Intelligence instance. The library of metrics is part of Oracle Analytics for Applications.
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 Analytics for Applications instance and the Oracle Transactional Business Intelligence instance.
- Create a custom BI Abstract role and associate it with the FAWService user.
Create a Custom BI Abstract Role
You create a BI Abstract role and associate it with the FAWService user.
Use the Security Console of Oracle
Applications Cloud. See Create Roles in the Security Console
- Sign in to Oracle Applications Cloud with your administrator credentials.
- Navigate to Tools and then to Security Console.
- In the Security Console, select the Roles tab, and then click Create Role.
- In the Create Roles wizard, on the Basic Information page, enter a role name such as OAX Custom Data Validation Role and a role code such as OAX_CUSTOM_DATA_VALIDATION_ROLE, and select BI - Abstract Roles as role category.
- In the Create Roles wizard, on the Role Hierarchy page, add the BI Impersonator role as a member of the newly created BI Abstract role.
- In the Create Roles wizard, on the Users page, add the FAWService user to the newly created BI Abstract role.
- In the Create Roles wizard, on the Summary page, verify the details, save, and then close the wizard.