update dimension

Post Reply
Moh
Posts: 43
Joined: Fri Aug 01, 2014 5:17 pm
OLAP Product: Cognos
Version: 10.1.1
Excel Version: 2010

update dimension

Post 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.
Attachments
Hierarchy.docx
(18.6 KiB) Downloaded 189 times
lotsaram
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

Post 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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Moh
Posts: 43
Joined: Fri Aug 01, 2014 5:17 pm
OLAP Product: Cognos
Version: 10.1.1
Excel Version: 2010

Re: update dimension

Post 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.
Post Reply