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