Handling slow report validation

Sometimes when you try to validate a report in Cognos Report Studio, it takes a long time. You will see the validating alert and then a blank dialog box appears and the Studio will seem to have frozen.

This recipe will show you how to fix this problem.

Getting ready

Create a simple report with all the columns from GO Data Warehouse (Query)/ / Sales/ / Products as query subjects.

How to do it...

In this recipe you will learn a small trick that can help you to avoid slow report validation. To do this, perform the following steps:

1. We will start by replicating the scenario that I am talking about. For that, open Query Explorer.

2. Open the query associated with the list object. It is called Query1 in the sample.

3. Add a detail filter with the following definition:

   [Product line code] in ?PL?
   and [Product type] in ?Type?
   and [Product] in ?Name?
   and [Product color] in ?Color?
   and [Product size] in ?Size?
   and [Product brand] in ?Brand?

4. Go back to the report page. Now click on the...