How to delete Prompt Parameters ?

[Nandini.t]

Hi all,

I have delaeted few prompts from the report and related query,filters everything but if i click on any filter if i click on parameters icon iam able to see old prompt related parameters which iam able to see again in the filter parameters window. so pl get me a solution to delete those.   

[HalfBloodPrince]

You have forgot to remove filters  related to that prompts. For Eg if prompt was added on a list click on list then go to filters and delete them which contains the parameter of ur deleted prompts  ?parameter? .

[Nandini.t]

I did that before but still seeing the paramers in query expression wiondow in paramaters icon.

[HalfBloodPrince]

Check you have used any parameter in query calculation.

[Nandini.t]

no i have not used

[HalfBloodPrince]

 Check ,if you have multiple list in the report then other list query may be using same parameter.

[mvjcognos]

Check whether u have created any variables using these parameters.....

Regards,
Royal

[Nike_BA]

I am having the same issue in Cognos 10.2.1. I have removed the value prompt from the prompt page and removed the reference to the parameter in the filter, but the parameter still appears in the parameter list and when I run the report, it causes an addition prompt window to appear requiring an input as if the parameter were still referenced in the filter. I have double checked all filters to make sure the parameter wasn't somehow duplicated in another filter, but I cannot find it.

[Lynn]

Did you try searching for it using the Edit > Find feature? Maybe it is referenced in a data item expression somewhere.

[cognos810]

Hello,
As Lynn suggests, simply removing the prompt UIs and the filters in the queries would still leave ?Parameter_Name? in the data item expressions in one of the queries somewhere. From report studio, do a Copy to clipboard (Tools > Copy Report to Clipboard)and then paste it into a text editor (Notepad, notepad++) then search for your parameter name. Once you find the text, look at the XML tag it is within, example: a Data Item expression or a filter expression. That's one way I use to figure such things out.

-Cognos810