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

Single Prompt prompting twice

Started by LOUM, 03 Nov 2011 12:28:51 PM

Previous topic - Next topic

LOUM

Ok,

One more please. I have a prompt page that iis directed to my Fiscal Year prompt on the quuery. When I run the report i get a prompt for Fiscal year, i enter it, then I get the prompt page also. Why is the report looking twice for the single prompt?

Arsenal

check that the query filter corresponding to the prompt has the same paramater as the prompt

LOUM

Arsenal.

Yes they are the same, I am stumped. Is there a way to see the resources behind it? Or were it is going? Pulling from?

blom0344

Copy the report xml source code to a text editor and scan the xml for the parameter

LOUM

Bloom thank you for the input. I can see a prompt for it in the code but I am not adept and deciphering the issue. Is there an easier way?

Bindiya

Check all the queries where you referred that prompt.. incorrect spelling or change in case also would prompt 2nd time.

LOUM

Diya,

Thank you, I am sitting here pulling my hair out..lol..

I have deleted all the filters and rebuilt them and I still get the same result, it is like whenever I choose the FY to filter it does it twice. All spelling correct. I have 2 other filters and they are not doing it. Can it be that it is the only one of the three filters that are required?

Bindiya

A filter being required or optioinal will not give raise to such issues. Probably you can try the below steps to actually see what is giving raise to this issue.

1. Delete all the filters that use FY.
2. Take XML and search for that prompt (this ensures that no where this prompt is referred in the report filters)
3. Now run the report, as we deleted the FY from filters, it should not prompt 2nd time (jus to ensure once again)
4. Then add the filter once again (hope you are not typing the filter name, jus drag it from the parameters section.
5. Then run the report once again.
6. If you use FY in more than one filter, then keep running the report each time after adding the filter.

LOUM

Diya,

Thank you, I did as you stated and it still did it. If I change it to an optional prompt similar to the other two it works fine. Thoughts?

Bindiya

hum.. not sure.. but feel something else is wrong.. coz even if prompt is not mandatory and the filter is required, it wld automatically make the prompt as mandatory when running the report but wld not prompt twice..

LOUM

That is why I am confused on this one. I am utilizing the report as I have it but, I want to understand the issue as well as it does not make sense.

;D