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

Unexpected prompts in Reports

Started by manishtirpude, 12 Mar 2009 07:50:45 AM

Previous topic - Next topic

manishtirpude

Hi All,
I have a report with a number of prompts.
When I run the report, cognos viewer asks for a Date Range (Start Date and End Date prompts) prompt even though there is no such prompt present in the report.

There are no StartDate and EndDate parameters present in the report, but report still displays this prompts while running.

StartDate and EndDate parameters are defined in a Business Layer query subject for some query items. When I use any query item in the report from this query subject, the report asks for Start Date and End Date even though the query item used does not have this parameters.

Please help me as I am tired of this issue.

rockytopmark

When you have filters in a query subject, you are eliminating the Minimized SQL functionality, and the Query Subject will now act like view, so regardless if you use these items in your query, the query subject itself is bound to the restrictions placed on it by having an embedded filter with parameters.

I suggest removing the filters from your query subjects, and create model filters that can be leveraged via click-n-drag in report authoring.