Multi-select in the prompt is not working properly in Cognos 8.1

cognos cognos-8
Hanane picture Hanane · Sep 23, 2008 · Viewed 11.4k times · Source

Changing a value prompt to a multi-select value prompt in Report studio, provide single select functionality. How can i get multi-select functionality?

Answer

Mike McAllister picture Mike McAllister · Sep 23, 2008

Look at the parameter associated with the prompt. Now go look and see how you use that parameter to filter the queries in your report. If you have the filter set as:-

[namespace].[table].[column] = ?MyParameter?

... then it doesn't matter that your prompt is a multi-select prompt, it will still run as a single selection prompt. Modify your filters so they are of the form:-

[namespace].[table].[column] in ?MyParameter?

This tells Cognos that your parameter can contain multiple values, and it will display the prompt accordingly.

Related questions

differences between "Cognos TM1 and "Cognos 10 BI

What the differences between "Cognos TM1" and "Cognos 10 BI"? Which one is consider as BI Tools by IBM?

Read More
Converting a Date Format to YYYYMM in Cognos Report Studio

I have a date column in a format 12 May, 2014 I want to convert that into yyyymm/ 201405 format. i tried multiple options like extract(year, sys_date)*100 + extract(month, sys_date))*100 cast(extract( year, sys_date), varchar(4)) + cast(extract( month, sys_…

Read More
Automatic filter for current month and year in Cognos Report Studio ver 10

I have a query item which filters records by a date column which is in format 'YYYYMM'. As of now I have hard coded the value [DateCol] = '201406' in Detail filters to get the current month and year records. …

Read More