Sunday, April 06, 2014

Upgrading Cognos Express 10.1 to 10.2

I recently completed a Cognos Express upgrade to version 10.2 and thought I would document some tips:
  • The download for Cognos Express is now 7.6gb! Leave plenty of time for download from the site and then transfer to your server.
  • You will find the install now switches from \Program Files (X86)\
    to \Program Files\ as it moves fully 64 bit. Make sure you update any scripts or TI's to the new path
  • The restores of CX you will have taken before the un-install of previous version will be sitting in the Backup directory of X86
  • IE is not great to work with Express Manager so make sure you have Chrome/Firefox handy.
  • The Performance Modeler Rich Client would not un-install at the start. I switched off UAC to get the un-install to work
  • Performance Modeler had lots of upgrades and changes in 10.2. Some of these changes may affect any contributor application you have. I had one application where there was a conflict and PM just deleted the Application. You will need to check your application in Performance Modeler and adjust to 10.2 
  • Make sure you remember to upgrade your tm1web .xls to .xlsx
  • Windows 8 is supported for Xcelerator client but Excel 2013 is not. You might consider using Excel 2010 (instead of or alongside) or using loose files
  • Also remember Excel 64 bit is not supported
  • If you want any changes to show in your workflow after updating the subset then you will need to go into Performance modeler and re-save the security rights
  • Check your Office Fix Packs and apply if needed
  • Your old web.config now changes to be tm1web_config.xml found in
    C:\Program Files\IBM\Cognos Express\webapps\tm1web\WEB-INF\configuration\tm1web_config.xml
    I changed the following values to be true to ensure websheets worked as per 10.1
    <add key="RecalcOnDataValidationChange" value="true"/>  
    <add key="RecalcOnPicklistChange" value="true"/>