COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: andershedin on 13 Jul 2022 02:19:10 PM

Title: Value prompts not displaying values using sql generated macro prompt
Post by: andershedin on 13 Jul 2022 02:19:10 PM
Hello guys,

I am working on a sql generated report, and cant get the value prompt to display drop down values. I have tried using both the ?org? in the filters pane and adding a #prompt('org')# in the where clause but it remains empty when clicking the value prompt, any idea?

thanks,

Anders