Greetings:
I'm writing a Turbo Integrator process and need to multiply by the weight of the parent of an element. For example, I have an account 14600 - C02. It's parent is 14600 and has a weight of -1. When I come across account 14600 - C02, I need to look up the weight of the parent. Any way of doing that?
Tubo Integrator function to return weight?
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Tubo Integrator function to return weight?
Rule functions can be used in a TI process too. Look in the help file for the rule functions for dimensions and elements and I'm sure you'll find what you are looking for. Keep in mind you can nest functions if need be.
-
- MVP
- Posts: 214
- Joined: Tue Nov 11, 2008 11:57 pm
- OLAP Product: TM1, CX
- Version: TM1 7x 8x 9x 10x CX 9.5 10.1
- Excel Version: XP 2003 2007 2010
- Location: Hungary
Re: Tubo Integrator function to return weight?
You can use the rule functions in TI:ChrisF79 wrote:Greetings:
I'm writing a Turbo Integrator process and need to multiply by the weight of the parent of an element. For example, I have an account 14600 - C02. It's parent is 14600 and has a weight of -1. When I come across account 14600 - C02, I need to look up the weight of the parent. Any way of doing that?
ELWEIGHT(dimension, element1, element2)
dimension A valid dimension name.
element1 The name of a consolidated element within the dimension.
element2 The name of a child of the consolidated element.
HTH
Best Regards,
Peter
Peter
-
- Posts: 52
- Joined: Mon Sep 20, 2010 2:20 pm
- OLAP Product: IBM TM1
- Version: 9.5.1
- Excel Version: 2007 SP2
Re: Tubo Integrator function to return weight?
That'll do it. Thank you!kpk wrote:You can use the rule functions in TI:ChrisF79 wrote:Greetings:
I'm writing a Turbo Integrator process and need to multiply by the weight of the parent of an element. For example, I have an account 14600 - C02. It's parent is 14600 and has a weight of -1. When I come across account 14600 - C02, I need to look up the weight of the parent. Any way of doing that?
ELWEIGHT(dimension, element1, element2)
dimension A valid dimension name.
element1 The name of a consolidated element within the dimension.
element2 The name of a child of the consolidated element.
HTH