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

Prompts in FM for Query Studio

Started by MehulModi, 12 Dec 2006 07:58:39 AM

Previous topic - Next topic

MehulModi

Hi All,

i have to define a prompt in Framework Manager within a query subject so that whenever a user pulls a column from that query subject in QS, he will be prompted for a value.
now the problem is the prompt type that cognos gives is an Edit Box prompt. Instead of this I need a Select Value prompt. I have tried by changing the Prompt Info property of the query item to Select Value, but still it is giving as an Edit box.
Can anyone tell me is this the way Cognos works or i can achieve this somehow?

PS: I have tried both the syntax for the prompt
column in ?prompt?
column in #promptmany()#

Thanks.

MFGF

Hi,

All that should be required is to define a filter in the definintion of the query subject with the syntax
[youritem] in (?a_parameter?)
then find the [youritem] query item and change its prompt type property to 'SelectValue'

The only difference I can see here is that I used parentheses around my parameter in the filter definition .

If you have tried this and it still gives you a textbox prompt, then you probably need to log it with Cognos telesupport.

Regards,

MF.

Meep!