Cognos Report performance enhancement

[jayatu]

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

[bdbits]

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