Feeders help

Post Reply
Kazêh
Posts: 44
Joined: Fri Apr 19, 2013 12:59 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007

Feeders help

Post by Kazêh »

hello guys, im trying to write a feeder for a rule with the following structure:


(CubeC)
['C'] = (DB('CubeA','dim1','dim2','dim3', 'A')* DB('CubeB', 'Dim1','Dim2','Dim3', 'B'))/ DB( 'CubeA','dim1','dim2','dim3','A16');

what i tryed so far was this:

In CubeA:

A=> DB('CubeC', dim1, dim2, dim3,'C');

in CubeB:

B=> DB('CubeC', dim1, dim2,dim3,'C');


and i was wondering how should i add the feeder for the variable 'A16', im not very good at feeders , i have no problems with only just multiplications, but when it has divisions and multiplications and others stuffs i get dizzy.

right now im reading this

http://www.ibm.com/developerworks/ssa/d ... ge620.html
and there is an example for division feeder

['A/B']=n:['A']/['B'];
['A']=>['A/B'];

but in this case C = ((A*B)/A16)

should i do something like this?

A=> C
B=> C
A16=> C

thanks for any tips
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: Feeders help

Post by tomok »

You need to step back and think about why a feeder is necessary. It's necessary when the result of a calculation is going to result in a non-zero value correct? In your example, if any of the components of the calculation are zero then the end result is going to be zero. If the value from Cube A is zero then it doesn't matter what comes from B. Likewise for the B to A cube relationship. So, feeding from both A and B is going to result in overfeeding. The only way to fix this is with conditional feeding. However, this is probably overkill, depending on your situation. If it were me, I would just feed from either A or B, not both.

If your calculation was adding A to B then you would need to feed from both, but since this is a division, you need to only pick one to feed from.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply