TM1 Forum

Hello.
Maybe somme may help me with the following topic. My source file is structred as follows:
V1 => element-1 , element-2 , ....
V2 => element-a , element-b, ....

I'd like to set up 2 hierarchies with TI
Groupe1
-element-1
-elemnt-2

Groupe2
-element-a
-elemnt2-c

When I'm trying to set up these 2 hierarchies with TI, it works fine if it's done separetly for Groupe1 and for Groupe 2.
When I set up 2 follwoing scripts in the same time in Metadata section and run the process:

DIMENSIONELEMENTINSERT(Dimension1,'',Groupe1,'c');
DIMENSIONELEMENTINSERT(Dimension1,'',V1,'n');
DIMENSIONELEMENTCOMPONENTADD(Dimension1,Groupe1,V1,1.000000);

DIMENSIONELEMENTINSERT(Dimension1,'',Groupe2,'c');
DIMENSIONELEMENTINSERT(Dimension1,'',V2,'n');
DIMENSIONELEMENTCOMPONENTADD(Dimension1,Groupe2,V2,1.000000);

I get the resultats as follows:
Groupe1
-element-1
-elemnt-2

Groupe2
-element-a
-elemnt2-c

+ all ellements in addition:
-element-1
-elemnt-2
-element-a
-elemnt2-c

How to define the script which allows to avoid all these single ellements in addition of 2 consolidated levels Groupe1 and Groupe2 ?
Thanks a lot for your help
Adam

Try to use dimension sort order button and sort by hierarchy,It might fix your issue.Thanks

Thanks a lot.
It helps, however every time the user select "All", he creates kind of 'disorder' in the hierarchy.

adasko wrote:Hello.
Maybe somme may help me with the following topic. My source file is structred as follows:
V1 => element-1 , element-2 , ....
V2 => element-a , element-b, ....

I'd like to set up 2 hierarchies with TI
Groupe1
-element-1
-elemnt-2

Groupe2
-element-a
-elemnt2-c

When I'm trying to set up these 2 hierarchies with TI, it works fine if it's done separetly for Groupe1 and for Groupe 2.
When I set up 2 follwoing scripts in the same time in Metadata section and run the process:

DIMENSIONELEMENTINSERT(Dimension1,'',Groupe1,'c');
DIMENSIONELEMENTINSERT(Dimension1,'',V1,'n');
DIMENSIONELEMENTCOMPONENTADD(Dimension1,Groupe1,V1,1.000000);

DIMENSIONELEMENTINSERT(Dimension1,'',Groupe2,'c');
DIMENSIONELEMENTINSERT(Dimension1,'',V2,'n');
DIMENSIONELEMENTCOMPONENTADD(Dimension1,Groupe2,V2,1.000000);

I get the resultats as follows:
Groupe1
-element-1
-elemnt-2

Groupe2
-element-a
-elemnt2-c

+ all ellements in addition:
-element-1
-elemnt-2
-element-a
-elemnt2-c

How to define the script which allows to avoid all these single ellements in addition of 2 consolidated levels Groupe1 and Groupe2 ?
Thanks a lot for your help
Adam

Hello,

try with a dimensionsortorder command

also if I am not wrong you can skip the dimensionelement insert on the children and do directly a dimensionelementcomponentadd

KR