When does a feeder stop feeding?

Post Reply
stex2727
Posts: 66
Joined: Tue Sep 15, 2009 11:29 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

When does a feeder stop feeding?

Post by stex2727 »

Take the data below where column A feeds column B which then feeds column C

Am I right in believing only 2 data points in Column C will be fed from Column B? or is it the 8 from column A?

Cheers
Steve


Feeders

A => B
B => C

Data

A B C
1 0 0
1 0 0
1 1 0
1 0 0
0 0 0
1 0 0
1 0 0
1 1 1
0 0 0
1 0 0
0 0 0
User avatar
Steve Rowe
Site Admin
Posts: 2419
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: When does a feeder stop feeding?

Post by Steve Rowe »

Hi,
It ought to be the second option with just the two from col B triggering feeders. It should be easy to test if you build this in a cube and then do check feeders in column C. Make sure you unload and reload the cube to get a true picture.

Cheers
Technical Director
www.infocat.co.uk
stex2727
Posts: 66
Joined: Tue Sep 15, 2009 11:29 pm
OLAP Product: TM1
Version: 9.4
Excel Version: 2007

Re: When does a feeder stop feeding?

Post by stex2727 »

Thought so, I don't know why I never tested it with check feeders in the past.

Thanks
Steve
jason68
Posts: 5
Joined: Fri Nov 28, 2008 11:05 am

Re: When does a feeder stop feeding?

Post by jason68 »

I'd be interested in the results of your test.

I'd expect a lot more feeding of C due to 'feeder chains' - where B is fed, C will always be fed even if the value of B is 0, so I would expect there to be 8 fed values in the C column..

Effectively you have built A=>B, A=>C and B=>C

J
User avatar
qml
MVP
Posts: 1094
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: When does a feeder stop feeding?

Post by qml »

Not so long ago we discussed this at length (here: http://www.tm1forum.com/viewtopic.php?f=3&t=5459) and the consensus reached was that fed cells keep on feeding regardles of their actual value (0 or non-0).
Kamil Arendt
Post Reply