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

No. of Queries generated by Cognos

Started by kalyan_y, 01 Sep 2011 04:27:10 AM

Previous topic - Next topic

kalyan_y

Hi all,

I have 2 queries, one for value prompt and the other for the List.
List Query has a filter based on the value prompt parameter.
Both the prompt and the list are on the report page.

I first placed the value prompt on the report page, and checked the Tools->Generated SQL, I see one query generated for this prompt.
Later, I placed the List and checked the Tools->Generated SQL. I now see three queries, 2 for value prompt and one for the List.

I removed the filter in the list and I see only 2 queries generated by Cognos one for prompt and the other for query.

I'm not quite sure why the Cognos is generating 2 queries for one prompt? Will this result in 2 hits to the database with the same SQL?