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
Quote from: avinashg.cognos14 on 06 Aug 2020 07:36:28 AM
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.