Page 1 of 1
update dimension
Posted: Mon Jul 20, 2015 12:54 pm
by Moh
Good afternoon Gentleman, I have a doubt ,I am destroying hierarchy and try to rebuilt again.Please see attachment.How to update the dimension after unwinding it.
Re: update dimension
Posted: Mon Jul 20, 2015 4:19 pm
by lotsaram
All I will say is that your code is doing as instructed. This is generally what code does.
Think through what the intended result is and the steps needed to get there and it should be obvious.
Re: update dimension
Posted: Thu Jul 23, 2015 11:36 am
by Moh
Thank you.I deleted attributes and write Dimensionelementinsert(dim,'','Apple','1');
#DimensionElementComponentAdd(DimName, ConsolidatedElName,ElName, ElWeight);
DimensionElementComponentAdd(DIM,'Total','Apple',1);
DimensionElementComponentAdd(DIM,'Total','Banana',1);
DimensionElementComponentAdd(DIM,'Apple','A',1);
DimensionElementComponentAdd(DIM,'Apple','B',1);
DimensionElementComponentAdd(DIM,'Banana','C',1);
DimensionElementComponentAdd(DIM,'Banana','D',1);
I am not getting the hierarchy as I want.I had started TM1 as junior then moved to Pentaho and moved back again to
TM1.