TM1 Forum

Does anyone already have a method to map out the elements of a dimension including a readable portrayal of the hierarchy? I have used an excel based method for some time but it's not brilliant, especially with large hierarchies. My own attempt didn't work out so well so i was wondering if anyone else had a way to show structures?

Steve Vincent wrote:Does anyone already have a method to map out the elements of a dimension including a readable portrayal of the hierarchy? I have used an excel based method for some time but it's not brilliant, especially with large hierarchies. My own attempt didn't work out so well so i was wondering if anyone else had a way to show structures?

Sigh, you couldn't have asked this 6 hours ago when I was still at work, already...

Yeah, I have something but it's in my Personal.xls workbook at the office; I don't have a copy of it here. Essentially it spits out an indented tree structure into one or more Excel worksheets. The only thing that I hadn't finished in it was an optional parameter to show weightings to the right of the element name.

If no-one else has posted anything by Monday I'll whack it up then.

If you could post that up here (Or in handy code) it will be very useful,

Jim.