How to create Alternative Hierarchy in TM1

[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

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

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

[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

[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

[declanr]

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> );

[TM1_Easy]

Thank you Declan R

[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);