how to improve the performance of reports

[inu]

HI
Can you tell me , if huge amount of data is there, then it creates the performance issue, Can we solve it .
How can improve the performance of the report.
Plz tell the steps.


Thanks
Inam

[MFGF]

Hi,

1. Optimise the data being returned. Don't bring back items you don't need.
2. Check for calculations that result in local processing on the Cognos server. Amend these as necessary to push as much of the work to the database as is reasonable.
3. Talk to your DBA and see if the data source(s) can be optimised for faster retrieval - eg adding appropriate indexes
4. Revisit the report requirements. Is someone trying to use Cognos as a data dump utility? If so, give them a slap with a wet fish and educate them on the benefits of using Cognos to deliver the results they need rather than dumping the data into Excel.

Just some random thoughts for late on a Friday afternoon...

MF.

[teresa.danna@gmail.com]

give them a slap with a wet fish

Nice! I'll have to use that sometime when responding to "dump" requests.

[kc9400]

Nice! I'll have to use that sometime when responding to "dump" requests.

I wish I could use that from time to time!