Hello Cognos Experts :)
acutally I´m using a prompt macro to filter a date. It is the following syntax:
where DUEDATE = #prompt('p_DUEDATE','date','current_date','','[Business Model].[p_DUEDATE]','')#
Now we want to filter multiple Dates. I thought I only have to change #prompt to #promptmany and the "=" to "in" to make it work. But it doesnt work.... :(
The new (wrong) Syntax is:
where DUEDATE in #promptmany('p_DUEDATE','date','current_date','','[Business Model].[p_DUEDATE]','')#
The error is: expected syntax: "[", "??(", "*", "+", "-", ".", "/", "||"
Does anyone know what I´m doing wrong?
Thx alot :)
DUEDATE in (#promptmany(xxxxx)#)