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.…

Read More