Cognos Report Queries generation

[Avi]

Hi,

I have a cognos report with around 20  pages with a list in each page. All these Lists have separate queries with common prompt page.
In the FM model we used to have a Query subject created which use SQL script for each of the list report.

when the report is run, every query will hit the database for all lists in the report.

Now that we have built a model by removing these queries, my doubt is will the report hit the database multiple time and how it will impact on the performance of the report.

Thanks

[MFGF]

Hi,

I have a cognos report with around 20  pages with a list in each page. All these Lists have separate queries with common prompt page.
In the FM model we used to have a Query subject created which use SQL script for each of the list report.

when the report is run, every query will hit the database for all lists in the report.

Now that we have built a model by removing these queries, my doubt is will the report hit the database multiple time and how it will impact on the performance of the report.

Thanks

Hi,

If you have 20 lists in your report, the report will fire 20 query requests to your database - one for each list container.

Cheers!

MF.