The Business Intelligence or Data Warehousing and Reporting systems need on-going maintenance. New data comes in every day, volume grows, 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.
We will just discuss the concept here and extend the 'Timing Report Execution' recipe from the chapter 'Some More Useful Recipes'.
We saw in the 'Timing Report Execution' recipe 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 the new job icon.
Add all the report views to this job. Change the Submission of steps to In sequence and Continue on error.
Change the defaults for all steps to PDF...