Handle slow report validation

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

This recipe will show you how to fix this problem.

Getting ready

Create a simple report with all columns from GO Data Warehouse (Query) | Sales | Product Query Subject.

How to do it...

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

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

3. Add a detail filter with following definition:

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

4. Go back to report page. Now hit the Validate button from toolbar.

5. Notice that you first get the Validating alert. Then a new dialog box appears which is blank for a while.

   

   Finally, all the...