How to re use query output in cognos 8.3 report studio

[krishbe]

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.

[mikewalker]

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.

[kattaviz]

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