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
Hierarchy with TI
-
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: Hierarchy with TI
Try to use dimension sort order button and sort by hierarchy,It might fix your issue.Thanks
"You Never Fail Until You Stop Trying......"
-
- Posts: 13
- Joined: Fri May 16, 2014 12:06 pm
- OLAP Product: Cognos Tm1
- Version: 10.1
- Excel Version: 10
Re: Hierarchy with TI
Thanks a lot.
It helps, however every time the user select "All", he creates kind of 'disorder' in the hierarchy.
It helps, however every time the user select "All", he creates kind of 'disorder' in the hierarchy.
-
- Posts: 58
- Joined: Mon Sep 27, 2010 2:46 pm
- OLAP Product: Cognos TM1
- Version: 10_1 10_2
- Excel Version: 2010
- Location: UK, CH, BE
Re: Hierarchy with TI
Hello,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
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