Report shows prompt page for hand made parameters in filters

[Invisi]

I have a report where I add some filters with parameters, like ?p_param?. These filters are optional. When I run the report, it comes with a prompt page, even though the filters are optional. Similar looking filters made from a Value Prompt don't show this behaviour. How do I turn this unwanted prompt page off?

[BigChris]

Wouldn't you expect a prompt page to show? How else is the user supposed to enter the value for the optional prompt?

[Invisi]

I use them for drill through.

[hespora]

instead of "?p_param?", use "#prompt('p_param','token','insertyourdefaultvaluehere')#", or promptmany in case of multiple value parameters.

[Invisi]

Thanks for the tip. What is token and can I leave the default value blank?

[MFGF]

Thanks for the tip. What is token and can I leave the default value blank?

Hi,

It's all in the user guide:

https://www.ibm.com/support/knowledgecenter/en/SSEP7J_10.2.2/com.ibm.swg.ba.cognos.ug_cr_rptstd.10.2.2.doc/c_cr_rptstd_wrkdat_creating_prompts_using_query_macros.html#cr_rptstd_wrkdat_creating_prompts_using_query_macros

Token, in this case, is the data type of the parameter. Using a Token data type simply means the prompt doesn't mess with the value and passes it as-is. The default value is there to make your prompt optional - ie if the user doesn't choose to respond, the default value is used. If you omit it, the prompt won't be optional.

Cheers!

MF.

[Invisi]

User guides? I am a man!!!  8)

I don't want any default value, I want no value to start and when I drill down, I may pass on a value. I have seven of such parameters in nine charts. Since the user drills down on one of these, only one has a value after drilling. And when first running the dashboard, none has a value. So this macro option sounds unusable to me. What alternative to I have?

[hespora]

User guides? I am a man!!!  8)

*Cough cough*.... your signature?

[Invisi]

*Cough cough*.... your signature?

Cr^p...  :(