If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos 8.3 performance issues

Started by tmclaugh, 27 Jul 2009 08:44:43 AM

Previous topic - Next topic

tmclaugh

Hi
We had a series of report running on cognos 8.1 and everything was going great and performance was good.  We upgraded to cognos 8.3 and a report that taking 17 seconds now take 3 minutes and sometime longer.  Any ideas anybody what could have caused this?  Nothing changed except the version of cognos.

Thanks
Tony

kmuller

Tony,
To be honest, 8v3 sucks.  We patched and patched it to get through various issues.  I would look at 8v4, it is much better.

That being said, have you pulled the sql from the report and ran it straight against the db to rule out a db issue?

Have you tuned you 8v3 install?

sk

Sune Jorgensen

We have found that the migration tool have set "Override Dimension Info" to "Yes".

You have to check every query for the property "Override Dimension Info" and if it is "Yes" then change it to "No".

After we have changed this in our reports - then it running much faster.