Monday, April 14, 2014

How to read IBM Cognos TM1 Version Numbers

Breaking this one down:

"10.1.0" = TM1 10.1.0

"00100" = FP1

"24600" = Build number, useful for IBM Support.

The important numbers are the middle ones (00100).

The first is part of the major release (aka 10.1.10000 = TM1 10.1.1)

The next 2 numbers are for the FP.

The last 2 numbers are for the IF (aka Hotfix).


10.1.00100.24600 = TM1 10.1.0 FP1

10.1.10000.26473 = TM1 10.1.1 Base Release

10.1.10100.31864 = TM1 10.1.1 FP1    (For 10.1.1 FP2 this would be 10.1.10200.xxxxx)

10.1.10104.34644 = TM1 10.1.1 FP1 IF4

Friday, April 11, 2014

IBM CDM User group

Check out the IBM CDM User Group and the useful videos they have:

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"/>