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

Problems with Cognos 8.2 upgrade

Started by congo, 07 Jun 2007 02:34:12 AM

Previous topic - Next topic

congo


We have just upgraded one of our three servers, the test server, to test the effects of the upgrade on the reports and cubes. The reports were all built in 8.1 and exported to the new 8.2 server. Some of the reports looked fine, but some didn't work at all and some displayed charts with strange values.
The ones that didn't work or looked strange all included charts. I have tried many things but they still refuse to work properly.

Have someone else encountered problems with the upgrade? How did you solve it?

larsonr

We ran into the exact same problem.  One thing to remember about charts:  They are visual cross tabs. 

Make sure if you have any calculations in your queries they are listed as calculated, have the correct aggregate functions and you are using the right roll ups.  8.2 seems to have gotten a bit more specific with the roll up types versus automatic in some cases.  I would start by individually going through each query you have in the reports to identify your key problem data items.

This helped us by going through each query one by one.  You may find it is just one data item throwing the report out of synch.

congo


Thanks for the tip.
I went through the queries as you said and found that it was a filter that wasn't working.
It was an quite complex detail filter of the type After auto aggregation" which didn't work as it should. But when I changed it to a summarize filter it worked better. Also I had to remove an cast_float() (which I had to use in order to get it to work in 8.1) and then the report worked! 

My conclusion though, is that it can be quite time consuming to find out why the reports won't work in the upgraded environment. But I guess it is worth the trouble. For the reports I haven't noticed any apparent improvements but when it comes to the cubes we have seen that they run quite a lot faster and the zero suppression is much better in the upgraded version.