How do you filter for a long list of values in a report?

[pacificbeavs]

I'm told that using Query Explorer in previous version of Cognos, you were able to copy/paste in long lists of values to filter for.  For example, if I wanted to filter for 100 values, I could copy them from Excel and paste them in to my query filter. 

As far as I can tell, that isn't possible in Cognos 11 when using a list report (or any other type for that matter).  It appears that editing the query with an "IN" statement is the best way to do that (e.g. IN ('abcd', 'efg', 'hij')).  Do you know of a way to filter for many values?  Some use cases require filtering for as many as a thousand values... Thanks!

[dougp]

Filter uses "in".
Create a prompt page and add and configure a text box prompt to multi-select = yes and multi-line = yes.
As-of 11.0.7, there is a bug in the text box prompt in the interactive viewer.  It may still be there in 11.0.9 and 11.0.10.  To use the non-interactive viewer, change the report's Run with full interactivity property to No.

[MFGF]

Filter uses "in".
Create a prompt page and add and configure a text box prompt to multi-select = yes and multi-line = yes.
As-of 11.0.7, there is a bug in the text box prompt in the interactive viewer.  It may still be there in 11.0.9 and 11.0.10.  To use the non-interactive viewer, change the report's Run with full interactivity property to No.

11.0.10? I'm guessing you must be wearing your clairvoyance cap today. Sadly, mine never seems to work, no matter how hard I concentrate ;)

MF.

[pacificbeavs]

Filter uses "in".
Create a prompt page and add and configure a text box prompt to multi-select = yes and multi-line = yes.
As-of 11.0.7, there is a bug in the text box prompt in the interactive viewer.  It may still be there in 11.0.9 and 11.0.10.  To use the non-interactive viewer, change the report's Run with full interactivity property to No.

Thanks- it worked although that's definitely much more involved than the previous version.  When I first create the filter, in the query it defaults to "=".  I then have to go in to my query, and then edit the filter to "IN".  Shouldn't Cognos do that automatically when you edit the filter properties to multi-select?

[dougp]

11.0.10? I'm guessing you must be wearing your clairvoyance cap today. Sadly, mine never seems to work, no matter how hard I concentrate

IBM Support acknowledged this problem fairly recently.  It may not have been soon enough to correct it in 11.0.10.  I know it's still a problem in 11.0.9.

[dougp]

Shouldn't Cognos do that automatically when you edit the filter properties to multi-select?

That sounds intuitive, but as a report developer, so you really want to give up that level of control?  Be careful what you ask for.

[charlie]

I had been pulling my hair out over why I couldn't get it to work and then came across this thread. I have 11.0.6 running in the environment. Now need to get back to the users on why they cannot paste multiple values in a text prompt after the upgrade to the new and shiny Cognos Analytics  ::)

[dougp]

The problem I described was corrected in 11.0.10.