Monday, April 14, 2014

How to read IBM Cognos TM1 Version Numbers

Breaking this one down:
10.1.00100.24600

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


Examples:

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:

https://ibm.biz/CDMUserGroup

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"/>
    http://www-01.ibm.com/support/docview.wss?uid=swg21653590

Monday, March 31, 2014

Power Saving and TM1 Performance

I was given this tip recently by a friend from Applix days.

If you are on Windows 2008 R2 then go into your Power Options via Control Panel and make sure the setting is "High Performance".

Do NOT select "Balanced".

It appears as if the processor scales down 50% when in balanced mode.


Tuesday, March 25, 2014

TM1 and JMeter

If you dont have LoadRunner available to you, yet you want to stress test your TM1 Application then its worth having a look at Apache JMeter.
JMeter you can download for free and then follow the instructions on IBM DeveloperWorks here:

http://www.ibm.com/developerworks/library/ba-pp-infrastructure-cognos_specific-page675/ba-pp-infrastructure-cognos_specific-page675-pdf.pdf

Sunday, March 02, 2014

Cognos TM1 10.2 Multi-threaded Query calculation fix

There looks to be an issue with MTQ in 10.2.
Looks like its best to ensure FP1 is applied then add MTQ.SingleCellConsolidation=false to your cfg

http://www-01.ibm.com/support/docview.wss?uid=swg21664467&myns=swgimgmt&mynp=OCSS9RXT&mync=E