Tag Archives: TM1 9.4

Replicating a Dimension Hierarchy in Excel

For those of us still using earlier versions of TM1 where Active Forms are not available, below is a set of VBA code that would enable you to recreate the dimension tree in your excel reports . In this example, we have a list of sales area managers from the Sales Managers dimension derived using the ELCOMPN formula. The objective is to make the list resemble the dimension hierarchy in TM1 as shown … Continue Reading

Installing TM1 9.4

To begin download the latest version of TM1 from the ‘My-IBM’ site. You will need a login to access the site. (http://www-01.ibm.com/software/data/cognos/) At the time of writing this the most current version of TM1 is 9.4 MR1 with FP2 being the latest hot fix. Once you have downloaded the version of TM1 you wish to install you should probably check your computer/server has everything needed to install TM1 I’ll break … Continue Reading

TM1 9.4 Presentation

Attached is the presentation I did for the Sydney TM1 Usergroup organized by Amendra Pratap. This covers most of the new 9.4 features.