Tubo Integrator function to return weight?

Post Reply
ChrisF79
Posts: 52
Joined: Mon Sep 20, 2010 2:20 pm
OLAP Product: IBM TM1
Version: 9.5.1
Excel Version: 2007 SP2

Tubo Integrator function to return weight?

Post by ChrisF79 »

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?
tomok
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?

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
kpk
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?

Post by kpk »

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?
You can use the rule functions in TI:
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
ChrisF79
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?

Post by ChrisF79 »

kpk wrote:
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?
You can use the rule functions in TI:
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
That'll do it. Thank you!
Post Reply