Cognos 10.1.1 Query studio static prompt values

[yarafatin]

   

How do I create a query studio prompt on a filter to have a static set of values to choose from instead of reaching out to the database to get the options available?

I created a "Pick values from a list" filter and chose "Prompt every time the report runs" options. When the report runs, the prompt page comes up and it takes a long time to load the values for the list. Is there a way I can create a static set of values to choose from ?

I cannot use Report Studio and so the advanced options are available to me.


Thanks in advance!