Hello,
I developed couple reports in Report Studio (Report Net). Some of them are running fast, but some of them take 3 min to display one page.
What should I check, and how can I improve performance of my reports??
How should I Analise SQL generated in report?
I have no acsees to Framwork Manager level
When we run SQL in the Query Analyser it is always returns result fast.
thank you for any suggestions.
Check on the sql. Preferrable cognos sql if ur model is set on that. Check the where clause, order by and so on...
Srik
By any chance you're using aggregates (totals etc) in your report? Just give this a try: change the fact item aggregation to calculated instead of total / automatic etc etc.... if it works I'll explain why it works....
Regards, wink
can you explain anyways :)
Yep, that would be nice to know!!
How can I improve the performance becides changing aggregations?
You could change processing mode from limited local to database only.
Try to use as much "case when ... " instead of "if then...". But keep in mind that this requires more from your database...