query execution

[mrcool]

Hi frnds,

               In cognos report,Iam having 3 queries.While running the report the queries execute parallely or in sequence? I mean after query1 query 2......etc?Please let me know..Thanks in advance

[Desperado]

The execution of the report will be from the prompt pages (Order of the page) . if you have two queries in the prompt it will execute the queries in the order of the prompts. if you have a search and select prompt it will execute the query only if you select the search.. for check boxes and others it will run once. after all these are executed your report query(main query ) will be executed. Hope this will clear your doubt. 

[mrcool]

I have two queries 1 and 2..For bothe queries am passing the year parameter from a prompt which query will execute 1st.

[Desperado]

it seems that you have the prompts in the report page. if that is the case, the query associated to your reportpage will run first and then when you select the year from the prompt, the second query will be submitted then and it runs at that time. for a clear info about which query runs first you can check your application server log. is this what you want ??

[ford]

query one

[mrcool]

Thanks for replying....