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?