Oracle^® Business Intelligence Applications Upgrade Guide > Upgrading Oracle BI Applications > Process of Upgrading the Siebel Analytics Repository >

Regression Testing the Analytics Repository Merge

In performing a regression test for the repository merge, the objective is to collect a set of logical SQL statements that are used for reports and to verify that they continue to work with the new metadata. For this purpose, it is recommended that you perform the following procedure.

To perform regression testing

1. Run the reports that are necessary to include in the regression suite. These reports might be a subset of the reports in the Presentation Catalog.
2. Collect the logical SQL generated in the previous step. You can do this using Usage Tracking or by parsing the query log file.

   For information about Usage Tracking, see Oracle Business Intelligence Server Administration Guide.

3. Execute the logical SQL against the old repository using the command line utility nQCmd.exe located in \OracleBI\server\bin, and save the results to a file.

   For information about the nQCmd.exe utility, see Oracle Business Intelligence Server Administration Guide.

4. Edit the logical SQL test scripts to account for the name changes or modifications resulting from the upgrade.
5. Execute the edited logical SQL against the merged repository, and save the results.
6. Compare the results from the steps above and try to explain the differences. If it is determined that these differences are due to the upgrade process, then you have to correct them manually.

   This repository now contains the merged content from the new OracleBIAnalyticsApps.rpd and the production repository.