Hi all,
I need to enhance the performance of some Cognos reports that are taking long time to run.
Can you guide me on what tools I can use to identify the root cause for the delay. I have tried using the Cognos Dynamic Query Analyzer to debug the queries but with no luck. The query tree generated has empty nodes with no information.
I am using a DQM enabled model on Cognos 10.2.1
Thanks,
Jayatu
Ask your database people to run a trace when you run your report. This will help determine if it is a database query issue, or something else.
Try taking a copy of your report, then removing things from the report and see if one particular item is causing the poor performance.
I had a link to this post from a long time ago, which I remember being quite detailed in output, but I do not think I have tried this in v10 so it may or may not still work.
http://www.cognoise.com/index.php/topic,14095.msg44678.html#msg44678 (http://www.cognoise.com/index.php/topic,14095.msg44678.html#msg44678)