Hey all,
I have some SQL input on a query that has:
WHERE
SD.YEAR_NUM = 2016
and I was wondering if its possible to have this be updated with values from a prompt? The prompt will be a selection of years.
Also the script has:
SD.MONTH_NUM_OF_YEAR in (4,5,6)
would it be possible to have the 4,5,6 be updated based on the multiple choices on a prompt?
Is it the usual ?prompt? syntax used in Cognos filters, or is it something else?
Many thanks
You can add prompt macros to your SQL statement, e.g.
SD_YEARNUM = #prompt('year';'integer')#
Use promptmany for multiple values.