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!
TM1 TI - Update Dimension Weight
-
- 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
Just add the following into the TI:
That will first break the current relationship and then create a new one with a negative weighting.
Code: Select all
DimensionElementComponentDelete ( sDim, sParent, sChild );
DimensionElementComponentAdd ( sDim, sParent, sChild, -1 );
Declan Rodger
-
- 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
...it works like charm. Thanks a lot!