COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: AnthonyJ on 04 Mar 2010 03:17:20 PM

Title: Static LOV in FM
Post by: AnthonyJ on 04 Mar 2010 03:17:20 PM
Is there a way to create a static LOV (ie. Yes, No) in Framework Manager and reference that in the prompt macro ?

Something similar to the below -


#promptmany('Display Detail','string','','','['Yes','No']')#
Title: Re: Static LOV in FM
Post by: AnthonyJ on 12 Mar 2010 12:17:38 PM
Anyone ?
Title: Re: Static LOV in FM
Post by: CognosPaul on 14 Mar 2010 09:17:20 AM
There is no way, in a relational model, to do this. What you can do instead is to create a table with all of the values you need.

Field
------
|Yes |
|No  |
|>   |
|>=  |
|=   |
|<=  |
|<   |
|And |
|So  |
|On  |
------


Then in your prompt macro you can do something like:

#prompt('par','string',sq('default'),'','filter([NS].[Table].[Field],[NS].[Table].[Field] in (' +sq('Yes') + ','+sq('No')+'))')#