Upgrade Content Store and Reports

[dmlong]

We have Cognos 8.4 running now and want to move to Cognos 10. We will be moving to a new Cognos and SQL Server box (separate VMs) :

1.What is the process to move the content store (SQL 2005 to SQL 2008)? If I import, will it ask for the new server name so that all the reports have the correct connection?

2.Do I have to change all of the reports manually to connect to the new data sources?

Thanks.

[MFGF]

Hi,

1. Probably the easiest path is to create a deployment export from within the Admin Console on 8.4, copy the deployment zip file onto your C10 server, create and initialise a new, empty content store in C10, then import the deployment using the Admin Console.

2. Provided your data sources are structured the same, all you should need to do is to define the data sources with identical names in C10, and you should be good to go.

MF.

[dmlong]

Thank you.

[dkalyan]

We are in the process of upgrading from 8.3 to 10.1. So far our critical sales reports are either failing or reporting incorrect numbers !!!!

It is a painstalking process, for one report that is based on a CUBE, the results differ between 8.3 and 10.1, however the results are the same when viewed thru Analysis Studio on 8.3 & 10.1.

Seamless upgrade is a far cry from reality. Am glad I have taken the approach of running parallel systems - 8.3 is still in production and 10.1 is in a test environment. 
I was recommended by IBM to perform the install on my production 8.3 system and I would see no problems.

[MFGF]

Some of the syntax checking for expressions was looser in 8.3 than in later versions.  Consequently it was possible to code expressions back then which were not strictly legal and returned results (for example, using a tuple() function on an object not defined as a member).  I'd hazard a guess that these kinds of issues will be causing the problems you are seeing in Cognos 10.  If we can help with any specifics, just post them up!

Good luck!!

MF.

[RobsWalker68]

Hi,

From what I've seen i tend to agree with MF.  It is very likely that if you upgrade from 8.3 to
8.4 instead of Cognos 10 then you would also experience the same sort of issue.

It's not so much an issue with an upgrade to C10 as it is what 8.3 would let you get away with that subsequent versions are stricter at enforcing.

Certainly, before upgrading its worthwhile rechecking your syntax conformity and making sure you conform to the rules.

Rob

[teverard]

Hi,

From what I've seen i tend to agree with MF.  It is very likely that if you upgrade from 8.3 to
8.4 instead of Cognos 10 then you would also experience the same sort of issue.

It's not so much an issue with an upgrade to C10 as it is what 8.3 would let you get away with that subsequent versions are stricter at enforcing.

Certainly, before upgrading its worthwhile rechecking your syntax conformity and making sure you conform to the rules.

Rob

This is what we have been told to expect as we are going from 8.3 FFP5 to 10.1.  It won't be "Boeing" seemless, but they are promising a much better experience that what it was like going from 8.1 to 8.3  :o

I am going to be proving out the multiple environment Gateway along with Lifecycle Manager in the next couple months.

[dmlong]

I started a small upgrade to 10.1 on Monday and will be done sometime mid-morning Thursday. It was not bad at all.

Thank's MFGF.

[AussiePete2011]

Hi there

I'd suggest installing LifeCycle Manager
http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_upgr_mngr.10.1.0.doc/ug_upgr_mngr_id306um_upgr_mngr_obj.html\

This allows you to test validate your 8.3 or 8.4 reports before migrating them so you have an idea before hand of what will and wont work.  It will save you some nasty surprises

Also if you are on 8.4 + an updater I cant recall off hand you can hook 8.4 public folders into 10 and run them from there within a c10 installation
See
http://www-01.ibm.com/support/docview.wss?uid=swg21459041

See how that goes
Cheers
Peter B