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.
Create a simple report with all columns from GO Data Warehouse (Query) | Sales | Product Query Subject.
We will start by replicating the scenario that I am talking about. For that, open the Query Explorer.
Open the query associated with the list object. It is called Query1 in the sample.
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?
Go back to report page. Now hit the Validate button from toolbar.
Notice that you first get the Validating alert. Then a new dialog box appears which is blank for a while.
Finally, all the...