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