My report has multi-select checkbox prompt for Business Division. With a normal query, I would simply use "IN ?BusinessDivision?" in the filter. How do I use this existing parameter in a Pass-Through SQL query? I tried putting "IN #?BusinessDivision?# in the WHERE clause, but that does not work. I get a validation error. Any ideas? I'm on Cognos 11.0.7.
Question marks denote a prompt alias which only works in regular query expressions. For SQL you need to use macro expressions.
?BusinessDivision? can become (#promptmany('BusinessDivision','integer')#)