Siebel Business Analytics Applications Upgrade Guide > Upgrading Siebel Business Analytics Applications > Process of Upgrading the Analytics Repository >

Regression Testing the Analytics Repository Merge

This task is a step in the Process of Upgrading the Analytics Repository.

In performing a regression test for the Siebel Business Analytics 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 Analytics Web 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.
3. Execute the logical SQL against the old repository using the command line utility nQCmd.exe located in \SiebelAnalytics\Bin, and save the results to a file.
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 SiebelAnalytics_78x.rpd and the production repository.