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

FM generated prompt LOV not displaying in RS

Started by AnthonyJ, 07 Apr 2010 10:50:55 PM

Previous topic - Next topic

AnthonyJ

I have searched all over the internet and cannot find an answer to my question.

I have created a Country prompt in FM as below.

[Dimension].[Country] in (#promptmany('Country','string','' ,'','[Dimension].[Country]')#)

Now, I would like to display the prompt in a prompt page. So I used a Value Prompt object which references the Country prompt. When I run the report, there is no list of values being displayed. I have explored changing all settings in the Prompt Info in FM -- Prompt Type, Display Item Reference and Use Item Reference, but still no LOV generated.

However, when using the "Generated Prompt" object, the LOV gets generated as a List Box, no option to change as Check Box Group.

Is this the default behavior for FM generated parameters ? If we need to display them in a prompt page, can we only use the "Generated Prompt" to display the LOV ? I would like to somehow change the List Box to a Check Box Group.


MFGF

Hi,

Defining this in FM will result in a default (generated) prompt being issued whenever this item is utilised in the report.  You can change the type of generated prompt using the PromptInfo properties in FM.  By default, the prompt should appear on a generated prompt page.

The alternative is to add a manual prompt page to a report, and drop a Value Prompt onto this, based on the ?Country? parameter from the item, but with a query utilising the original Country item (not this item or you will have a loop).  You will then have absolute control over the prompt properties etc.

Hope this helps!

MF.
Meep!

AnthonyJ

Thanks for your feedback. So it looks like the only alternative to have absolute control over the prompt properties is to create the prompt in RS rather in FM. Reason why i need to create the prompts in FM is to promote reusability. As the properties for a generated prompt is limited, is there a way, including coding javascript, that enables a developer to gain control of the prompt properties ?