If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Dynamic Select Prompt Display AS

Started by FatCat, 22 Jan 2008 03:22:14 PM

Previous topic - Next topic

FatCat

I want to dynamically display the values in a prompt.
However I know of one code that needs to be translated.

Ex.

'abc' = 'Red'

I do not want to do a Static Collection because it is possible other codes may enter
the table.


If I do a case statement on the table the issue is the parameter gets set to the case statement condition which does not exist in the table.

Ex.

Case when

column='abc' then 'Red'

else column

The parameter will be set to RED thus making the filter on the main query useless.

Thoughts???

jethro89

Hi, you can combine a static list and the dynamic query in a prompt. I would have your query, but filter out the value you need to translate, then in the static list, do your translation. Let me know if you have any issues or if this doesn't help.
Hope this helps.
anita