My Report of Cognos 8.3 is directly accessing database to fetch records. There are 10 different queries used in the same report. Almost 9 of the queries are using the same tables with a slight difference in select columns and greatly differs only in the filter condition applied. Can anyone suggest me
1) how to minimize the run time of the report as i could see different queries which differs with filter condtion and slightly on select columns. We are in a production enviornment and doing changes to the framework manager or the database is not much likely welcome. The report output uses the PDF format. Please suggest.
Do all the queries have the same filters?
If so, just create 1 query with all the data items you need, then use this for all the elements on your report.
Hi,
Have you tried query reference. Build one query without any filters and create the required queries with filters while referencing the base query.
HTH