TM1 TI - Update Dimension Weight

Post Reply
mama
Posts: 10
Joined: Wed May 01, 2013 1:02 pm
OLAP Product: TM1, Jedox, Powerplay, SSAS
Version: TM1 10.2.2
Excel Version: 2013

TM1 TI - Update Dimension Weight

Post by mama »

Hi,
I am recreating a parent/child hierarchie in a dimension with a TI process. This runs smooth, it's no problem at all. At the end I am getting a nice unbalanced hierarchie which is needed for the chart of accounts.
But now I am struggling with the manipulation of the weight.
Is there a TI function which allows to update the weight? It should be -1 for cost accounts.
Thanks!
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: TM1 TI - Update Dimension Weight

Post by declanr »

Just add the following into the TI:

Code: Select all

DimensionElementComponentDelete ( sDim, sParent, sChild );
DimensionElementComponentAdd ( sDim, sParent, sChild, -1 );
That will first break the current relationship and then create a new one with a negative weighting.
Declan Rodger
mama
Posts: 10
Joined: Wed May 01, 2013 1:02 pm
OLAP Product: TM1, Jedox, Powerplay, SSAS
Version: TM1 10.2.2
Excel Version: 2013

Re: TM1 TI - Update Dimension Weight

Post by mama »

...it works like charm. Thanks a lot!
Post Reply