Monthly Archives: April 2012

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

This entry was posted in IBM Cognos TM1, TM1 pre 10.1, Training Material and tagged IBM Cognos TM1, TM1 9.1, TM1 9.4, TM1 9.5, TM1 VBA, Visual Basic. Bookmark the permalink. | Tagged IBM Cognos TM1, TM1 9.1, TM1 9.4, TM1 9.5, TM1 VBA, Visual Basic | 2 Comments