TM1 Forum

Hi:

I am quite new to TM1 I am trying to build a hierarchy in a division of sales people and clients they look after.

In this dimension I have the hierarchy currently set up as:

All Client Numbers (top)
|- Client Head office
|-|-Client Division
|-|-|-Client Region
|-|-|-|-Client Branch
|-|-|-|-|-Client Number

I have also successfully added individual sales people and client numbers that they are responsible for underneath this. This is appearing as a separate additional hierarchy in this same dimension after the one above:

Sales Person
|-Client Number

However to meet the requirement I need to have a structure that looks like

All Client Numbers (top)
|-Sales Person
|-|- Client Head office
|-|-|-Client Division
|-|-|-|-Client Region
|-|-|-|-|-Client Branch
|-|-|-|-|-|-Client Number

Sales person should pick up only the Clients that that particular Sales person is responsible for - again it already does this in this Sales Person hierarchy described above.

In looking into this, using ELPAR seems to come up as one possible way to do it? But as there are so many parents in this particular case does it complicate the matter - I would need nested ELPARs in this?

And in researching that, another option seemed to be to use attributes to store the parent elements but views will need to be created down the line on this (attributes can't be used in views?)

Thank you in advance for any advice,

Check bedrock ,There are TI scripts there doing exactly what you want:
http://bedrocktm1.org/ Thanks

Thanks for the reply. Is it too onerous without Bedrock? I don't believe we use it so would like to try the 'old fashioned way' if at all possible.

Thank you again,

Well, Bedrock is a) free and would b) give you some clues as to how to do what you want to do, even if you don't use the Bedrock code.

Thanks again. I am having a look at Bedrock now. I am a bit confused as to which of the processes would enable me to do this. Could anyone please help point me in the right direction? Again I am very new to TM1.

Thanks for your patience, and many thanks again for your help.

These processes should give you an idea to you to approach your task:

Bedrock.Dim.Hierarchy.Unwind.Consolidation.pro

Bedrock.Dim.AllConsols.Delete.pro

Bedrock.Dim.Hierarchy.Unwind.All.pro etc. Thanks