In some other forum I came across a solution to add multiple values in a text box prompt.
Say you want to filter a report on:
DEPARTMENT in (‘A’,’B’,’C’)
Drag in a text box prompt with a parameter: p_department
In the query add a filter with the next syntax:
[DEPARTMENT] in (#csv(split(‘,’,prompt(‘p_department’,’token’)))#)
Thanks to CognosPaul on www.cognoise.com