TM1 Forum

Hi all

Can anyone help me with a feeder for this please? The leaf level is calculating the indicator fine but it is not rolling up to the consolidations so I assume a feeder is needed but I've never fed attributes before. I've had a go at putting a rule in the control cube but it tells me it's not a valid string expression so I'm not sure if I'm missing something here.

This is the part of the rule:

['Actuals','Started in Month'] = N:
IF(
NUMBR(SUBST(ATTRS('021 - Employees',!021 - Employees,'Start_Date'),6,2)) = NUMBR(SUBST(ATTRS('003 Main - Periods',!003 Main - Periods,'Number'),3,2)) &
NUMBR(SUBST(ATTRS('021 - Employees',!021 - Employees,'Start_Date'),1,4)) = NUMBR(!002 Main - Years),1,0
);

missspeedy23 wrote:The leaf level is calculating the indicator fine but it is not rolling up to the consolidations so I assume a feeder is needed but I've never fed attributes before.

Well don't start now. You would never feed a rule in an attribute cube. Never. But that is besides the point as your rule is not in an attribute cube. You are just referencing attribute values for the calculation. The rule needs to be fed like any other rule. You haven't really followed the the RFAG so we don't have much to go on. What is the structure of the cube? Obviously it includes dimensions employee and period and a measure, but what else? What is the base loaded data? Is there a measure loaded at employee level which can be used to feed 'Started in Month'? If yes then that is what you use to feed. If no then you may have to come up with something else or overfeed, but no one will be able to provide you with an answer in this case without information as to data content and granularity and cube structure.

missspeedy23 wrote:I'm not sure if I'm missing something here.

Undoubtedly.

Apologies, I've attached the additional information re the cube.

The data is just loaded into 2 measures - value and FTE. Value holds what has been paid to a person and FTE what their full time equivalent is (i.e. 1, 0.8 etc).
I'm not sure I can use either of those 2 to feed the cell because the 2 aren't dependent on each other. So the started in month flag may be 1 but the person may not have actually been paid at that point so the other measures will be zero. I have tried using the value and FTE measures to feed the cell but that doesn't work.

I have to admit feeders are one of the things that always get me

You can put this information using TI process (as far as I understood, it is cube with uploaded data). So there is no need to use any rules and feeders.