Regression testing
Business Intelligence and Data Warehousing and Reporting systems need ongoing maintenance. New data comes in every day, volume grows, and business rules change. All this can impact the existing reports structurally and performance-wise. In this recipe, we will quickly see one way of doing regression test every time anything changes in the system.
Getting ready
We will just discuss the concept here and extend the Timing report execution recipe of Chapter 12, More Useful Recipes.
How to do it...
We saw in the Timing report execution recipe of Chapter 12, More Useful Recipes that we can create Report View, save certain parameters for it, and then run it in the background.
We will now add upon this concept. For regression, you will need to create report views for each report. Save all of them in one folder.
Create a new job by clicking on the new job icon.
Add all the report views to this job. Change Submission of steps to In sequence and Continue on error.
Change the defaults for...
