[Closed]performance reports in report Studio

[otsizh]

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.

[BIsrik]

Check on the sql. Preferrable cognos sql if ur model is set on that. Check the where clause, order by and so on...

Srik

[wink]

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

[CoginAustin]

can you explain anyways :)

[sir_jeroen]

Yep, that would be nice to know!!

[otsizh]

How can I improve the performance becides changing aggregations?

[sir_jeroen]

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...