update dimension
-
- Posts: 43
- Joined: Fri Aug 01, 2014 5:17 pm
- OLAP Product: Cognos
- Version: 10.1.1
- Excel Version: 2010
update dimension
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.
- Attachments
-
- Hierarchy.docx
- (18.6 KiB) Downloaded 189 times
-
- MVP
- Posts: 3704
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: update dimension
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.
Think through what the intended result is and the steps needed to get there and it should be obvious.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- Posts: 43
- Joined: Fri Aug 01, 2014 5:17 pm
- OLAP Product: Cognos
- Version: 10.1.1
- Excel Version: 2010
Re: update dimension
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.
#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.