Feeders for Zero values

[maps]

Hi Guys,

I have a question about creating a Feeder for the following cube:



I understood the Feeder-logic works like this: Look in Cell "Mes1". If there is a non-zero Value in the cell Flag the corresponding cell in "Mes3" so that TM1 can use this value for the consolidation (The Rule gonne be calculated anyways).

The example above behaves like I expacted.

But how would you write the correct feeder which also flags the 0-value?

Any ideas?

[tomok]

But how would you write the correct feeder which also flags the 0-value?

Based on the picture you have shown it's not possible. Feeders have to feed off an actual value. In your case the only element that has values is Mes1, and it doesn't have values in all the cells. The only way you are going to be able to feed this rule, based on what you are showing us here, is going to be to create another element in the Mes dimension, call it MesFeed, and load a value of 1 to it. Then you can do:

{'MesFeed'} => ['Mes3'};

[jstrygner]

From your example you can see, that there will always be a non-zero value in Mes3 leaf elements. That is why you could just feed the consolidation cell (to get all the leaves fed):

Code: Select all

['Mes1', 'cons']=>['Mes3', 'cons'];

But this one will not work properly when all of the Mes1 leaf cells are zero (or not fed, but this is another story). So in this case you can apply tomok's separate non-empty cell, that would be used as a feeding source (and hit the consolidation cell on Mes3 column).

Remember, although Mes3 is calculated based on Mes1, it does not mean you need to feed Mes3 from Mes1. You just need to make sure, that everything that should be fed is fed (and everything that doesn't have to be fed, should not be, unless you don't have a choice ).

HTH

[maps]

Thanks a lot for the explanations. I think it is clear. I'm pretty new in TM1 and I thought maybe I missed a special command or something for this cases.

Is there a way to feed the ['Mes3'] ? In the sense of flag all cells in ['Mes3'] ?

Like tomok said I could also implement a "helping-element" which is always non-zero and use this to feed ['Mes3']. But can I save this line somehow?

[jstrygner]

Is there a way to feed the ['Mes3'] ? In the sense of flag all cells in ['Mes3'] ?

maps, if it helps, just see on the picture what I meant. I used here tomok's additional element approach, one filled cell is enough to feed the whole Mes3 column if you hit the top consolidation element in Product dimension (remember that the assumption was all the values are non-zero in the Mes3 column, so feeding all leaves does not cause overfeeding).