TM1 Forum

Maybe I don't understand something about feeders, that's why I'm asking.

I have the measure dimension: fin_percent is calculated using a rule: Finally Station dimension looks like: alloc_amount for TV and Radio is copied from TV Stations and Radio Stations consolidations by TI process (for performance optimization), so fin_amount for each station including TV and Radio elements should be always fed if there is any value for alloc_amount, consequently fin_percent should be fed as well.

However I have a problem with one TV station, for some reason when look at its fin_percent at FTE CE Group ("Cost Element" dimension consolidated element), it displays the right value: 2.91%


also when I click check feeders it shows that it's fed, but when I suppress zeroes that fin_percent disappears, so in fact it is not fed.

What am I missing here?

I don't know why but I was not able to attache the 4th screen shot, attaching it here:

However I have a problem with one TV station, for some reason when look at its fin_percent at FTE CE Group ("Cost Element" dimension consolidated element), it displays the right value: 2.91% After zero-suppression:

I think you are running into trouble with C level rules and feeders.

Feeders only happen at the N level, think ticks in a box that says calculate me.

C level cells are only "fed" if at least one cell under it is fed and non-zero.

So in your first view in the second post, since there is no value under the problem cell (that I can see in the screen shot). The C level cell is not "fed" and so does not display.

Cheers,

Steve

Hi Steve

Thanks for you reply. This is exactly what I thought initially, but was not sure about if feeders work on C-level.

So I need that Cost Element consolidation to be calculated even there is no child elements with values.

One solution that comes to my mind is making fin_percent to be a consolidated element and having at one child element which will be feeding it
For example, I could move fin_amount under fin_percent

Does anybody have any better recommendation?

vovanenok wrote:Hi Steve

Thanks for you reply. This is exactly what I thought initially, but was not sure about if feeders work on C-level.

So I need that Cost Element consolidation to be calculated even there is no child elements with values.

One solution that comes to my mind is making fin_percent to be a consolidated element and having at one child element which will be feeding it
For example, I could move fin_amount under fin_percent

Does anybody have any better recommendation?

Unless you have a scenario where fin_percent will be calculated for actuals but input for forecast then there is absolutely no reason for this to be an N element. Rather it can be a C with fin_amount as a child which acts as a "feeder". Nothing changes to the rule other than it becomes C: and you remove the feeder as it is now redundant.

Hey lotsaram, thanks for your answer, yes this is what I've done to resolve my issue.

Please clarify if there is any case when we can use a consolidated element on the left side of feeder statement, as I found this example http://ykud.com/blog/cognos/tm1-cognos/ ... ed-feeders which shows feeding from a consolidated element, but it didn't work in my case

Feeders are substitute DATA. Therefore it is critical to realize feeders only exist for leaf cells. Putting C element on the left hand side of a feeder is shorthand for all ultimate N element descendants of the C element. On the right hand side the element name evaluated by !dimension are the leaves not the C element. This is important to understand.

lotsaram wrote:Feeders are substitute DATA. Therefore it is critical to realize feeders only exist for leaf cells. Putting C element on the left hand side of a feeder is shorthand for all ultimate N element descendants of the C element. On the right hand side the element name evaluated by !dimension are the leaves not the C element. This is important to understand.

hey lotsaram, thank you so much for the explanation! Now that puzzle is completely solved for me!