Static LOV in FM

[AnthonyJ]

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']')#

[AnthonyJ]

Anyone ?

[CognosPaul]

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:

Code Select Expand

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