COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: srini2mk on 06 May 2011 11:10:15 AM

Title: Prompt appearing twice
Post by: srini2mk on 06 May 2011 11:10:15 AM
I have a parameter p_filter and a associated prompt in a report. This is present in the prompt page. When I run the report, I get this prompt first as a text box and whne I enter some text in it and click on finish, it takes me to the prompt page having all the prompts. When I have a prompt page, why AM I being prompted first for this parameter and then to the prompt page.Thanks for all your help

Thanks,
Srini
Title: Re: Prompt appearing twice
Post by: Sunchaser on 18 May 2011 09:49:45 AM
Hi,

It sounds like one of the queries used for one or more objects in the prompt page is filtered with one of the parameters.
So before Cognos is able to launch the prompt page, you have to give a value to the parameter.

Regards,
Vinc.
Title: Re: Prompt appearing twice
Post by: Amruta Gandhi on 23 May 2011 03:51:17 AM
Hi,
You can once again verify if both the parameters are exactly the same, the parameter of the prompt as well as the one defined in the filter of the query i.e. p_filter. Any small spelling mistake in them, will lead to a different parameter. Also, if the requirement allows, you can provide default selection to the prompt and then check its functioning.