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
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.
Quote from: MFGF on 04 Apr 2014 10:09:54 AM
give them a slap with a wet fish
Nice! I'll have to use that sometime when responding to "dump" requests.
Quote from: teresa.danna@gmail.com on 05 May 2014 12:39:06 PM
Nice! I'll have to use that sometime when responding to "dump" requests.
I wish I could use that from time to time!