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?
Wouldn't you expect a prompt page to show? How else is the user supposed to enter the value for the optional prompt?
I use them for drill through.
instead of "?p_param?", use "#prompt('p_param','token','insertyourdefaultvaluehere')#", or promptmany in case of multiple value parameters.
Thanks for the tip. What is token and can I leave the default value blank?
Quote from: Invisi on 25 Aug 2017 03:31:58 AM
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.
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?
Quote from: Invisi on 25 Aug 2017 04:53:57 AM
User guides? I am a man!!! 8)
*Cough cough*.... your signature?