If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Performance of queries

Started by johny.cbi, 02 Sep 2011 04:03:54 PM

Previous topic - Next topic

johny.cbi


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

blom0344

8.4 sports the property to execute queries concurrently. Perhaps you could try and test whether this makes a difference?

kalyan_y

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.

johny.cbi

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.

Arsenal

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