How Cognos processes Queries ?

[Sunchaser]

Hi,

I've a other "general" question (still in report studio):
Let's say I have:
. a page_set based on one field of a query objet named "q_main".
. page 1 (in this page_set), based on "q_main", containing a objects based on a query Q1 with a master_detail relation with q_main
. page 2 (in this page_set), based on "q_main", containing a objects based on a query Q1 with a master_detail relation with q_main

As my SQL of q_main is doing "insert" in a table before retrieving datas, I can see that this query is called 3 times, and it sounds very strange to me:
I thought that Cognos would have used the query one times and used the data all along the process of creating the pages of the report (PDF).

Is it a normal  way or is there a particular configuration ?

Thanks,
vinc.

[Sunchaser]

Hi,

I don't know if I wasn't clear enough (it's possible), but I'd really like to know why the Query is called 3 times, and if it could be changed.

Thanks,
vinc.