Cognos 8.4
DB: Tearadata
I have a list report which contains 3 queries and referencing to 1 query
when the report hits to Database the query refers to 3 queries instead of 1 query
is there any chance or solution to hit the data base only with 1 query to reduce the report performance.
please share your ideas. Thanks in Advance
8.4 sports the property to execute queries concurrently. Perhaps you could try and test whether this makes a difference?
How many queries exist in your report? Is the query associated with your list is a reference to other queries?
For every data container on the report, Cognos will generate a separate query. You could try minimizing the data containers or could use the query properties: Use Local Cache set to Yes, which caches the result.
If your report has 3 queries, and you have got only one list on the report page, then the no. of queries generated by Cognos is only one.
Total Queries : 7 - out of which 4 are report queries and 3 are Prompt queries
there are couple of report pages, In a report page, one query is referenced to two List reports.
Does your model have multi fact (maybe with multi grain too?) set up? Reason I'm asking is for some specific queries, especially in a multi fact model, Cognos generates what is called a stitched query - it will fire off multiple queries to the Db and then "stitch" the result set together locally (on the app server) and present it on the report. This is one instance when one report can end up sending multiple queries to the DB
Some full outer joins at the report level can have similar firing off of multiple queries