TI that finds parent of parent of parent of parent and moves it

Post Reply
wigglyrat
Posts: 67
Joined: Wed Sep 02, 2015 3:09 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: 2010

TI that finds parent of parent of parent of parent and moves it

Post by wigglyrat » Tue Oct 13, 2015 10:37 am

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,

BariAbdul
Regular Participant
Posts: 420
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: TI that finds parent of parent of parent of parent and moves it

Post by BariAbdul » Tue Oct 13, 2015 12:05 pm

Check bedrock ,There are TI scripts there doing exactly what you want:
http://bedrocktm1.org/ Thanks
"You Never Fail Until You Stop Trying......"

wigglyrat
Posts: 67
Joined: Wed Sep 02, 2015 3:09 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: 2010

Re: TI that finds parent of parent of parent of parent and moves it

Post by wigglyrat » Tue Oct 13, 2015 2:01 pm

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,

Paul Segal
Community Contributor
Posts: 261
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: TI that finds parent of parent of parent of parent and moves it

Post by Paul Segal » Tue Oct 13, 2015 2:08 pm

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

wigglyrat
Posts: 67
Joined: Wed Sep 02, 2015 3:09 pm
OLAP Product: TM1
Version: 10_2_2
Excel Version: 2010

Re: TI that finds parent of parent of parent of parent and moves it

Post by wigglyrat » Wed Oct 14, 2015 9:59 am

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.

BariAbdul
Regular Participant
Posts: 420
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: TI that finds parent of parent of parent of parent and moves it

Post by BariAbdul » Wed Oct 14, 2015 12:54 pm

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
"You Never Fail Until You Stop Trying......"

Post Reply