Page 1 of 1
How to create Alternative Hierarchy in TM1
Posted: Sun Nov 30, 2014 7:09 am
by TM1_Easy
Hi,
I want to create an alternative hierarchy in Inventory dimension, this dimension already have two hierarchies and I want to create another hierarchy with different consolidation levels.
Could you please explain me how to create an alternative hierarchy.
Thank you in advance
John
Re: How to create Alternative Hierarchy in TM1
Posted: Sun Nov 30, 2014 10:38 am
by declanr
Since you already have 2 hierarchies you can see that every element is able to have multiple parent elements and you just add them either manually or through TI with DimensionElementComponentAdd; you just have to avoid using the same consolidation names in both hierarchies if you want it to have different children.
Re: How to create Alternative Hierarchy in TM1
Posted: Sun Nov 30, 2014 1:07 pm
by tomok
In TM1 there really is no concept of an "alternate" hierarchy. A hierarchy is nothing more than a tree of parent/child relationships and you can have an unlimited number of those in TM1. How to create parent/child relationships is covered more than adequately in the TM1 documentation.
Re: How to create Alternative Hierarchy in TM1
Posted: Mon Dec 01, 2014 4:21 am
by BariAbdul
How to create parent/child relationships is covered more than adequately in the TM1 documentation.
As Tomok suggested ,You might find it in Turbo Integrator guide's chapter 9: Advance Scripting :
http://public.dhe.ibm.com/software/data ... 1_turb.pdf Thanks
Re: How to create Alternative Hierarchy in TM1
Posted: Tue Dec 02, 2014 8:14 am
by TM1_Easy
Thank you all for your kind replies. Sorry, I forgot to mention that I want to create through TI.
Could you please send me the steps to follow.
Cheers,
Jo
Re: How to create Alternative Hierarchy in TM1
Posted: Tue Dec 02, 2014 8:20 am
by declanr
TM1_Easy wrote:Thank you all for your kind replies. Sorry, I forgot to mention that I want to create through TI.
Could you please send me the steps to follow.
Cheers,
Jo
Code: Select all
DimensionElementComponentAdd ( <Dimension Name>, <Parent Name>, <Child Name>, <weighting> );
Re: How to create Alternative Hierarchy in TM1
Posted: Tue Dec 02, 2014 8:21 am
by TM1_Easy
Thank you Declan R
Re: How to create Alternative Hierarchy in TM1
Posted: Tue Dec 02, 2014 10:42 am
by BariAbdul
In addition to what Declan said,Please go through the Advance scripting of TI guide,It clearly explains all the steps in detail for example below code:
Code: Select all
The statements should appear as follows:
Prolog>
#****GENERATED STATEMENTS START****
#****GENERATED STATEMENTS FINISH****
DIMENSIONDESTROY(’unbalanced’);
DIMENSIONCREATE(’unbalanced’);
Metadata>
#****GENERATED STATEMENTS START****
#****GENERATED STATEMENTS FINISH****
DIMENSIONELEMENTINSERT(’unbalanced’,’’,G1,’n’);
DIMENSIONELEMENTINSERT(’unbalanced’,’’,TOTAL,’c’);
DIMENSIONELEMENTINSERT(’unbalanced’,’’,NORTH,’c’);
DIMENSIONELEMENTINSERT(’unbalanced’,’’,TK1,’c’);
DIMENSIONELEMENTCOMPONENTADD(’unbalanced’,TOTAL,NORTH,1.000000);
DIMENSIONELEMENTCOMPONENTADD(’unbalanced’,NORTH,TK1,1.000000);
DIMENSIONELEMENTCOMPONENTADD(’unbalanced’,TK1,G1,1.000000);