Testing and Validating a Repository
• You have finished building an initial business
model and now need to test and validate the
repository before continuing. You begin by
checking the repository for errors using the
consistency checking option. Next you load the
repository into Oracle BI Server memory. You
then test the repository by running an Oracle BI
analysis and verifying the results. Finally, you
examine the query log file to observe the SQL
generated by Oracle BI Server.
To test and validate a repository
perform the following steps:
• Check Consistency
• Disable Caching
• Load the Repository
• Set Up Query Logging
• Create and Run and Analysis
• Check the Query Log
Check Consistency
• 1. Select File > Check Global Consistency.
Check Consistency
• 2. You should receive the message Business model "Sample Sales" is
consistent. Do you want to mark it as available for queries?
• 3 .Click Yes. You should receive the message: Consistency check didn't
find any errors, warnings or best practice violations.
• If you do not receive this message, you must fix any consistency check errors
or warnings before proceeding.