Help with a Feeder

[Paul-TM1]

Hi All,
I need help with a feeder. For some reason, it's not working for a few elements. The rule is working but the feeder works partially.

Can you please tell me how to fix it?

Source Cube	Dimensions	Feeder
Labor_ASDF	Employees_ASDF Months Projects Versions Labor Calcs	Code: Select all ['Hours']=>DB('SumCostIWO1-LaborSummary',!Projects,!Employees_ASDF, DB('Labor-ASDF',!Employees_ASDF,!Months,!Projects,'Forecast','PLC') ,!Months,!Versions, attrs ( 'Employees_ASDF' , !Employees_ASDF, 'EmplGroup' ), 'Hours'); ['Cost']=>DB('SumCostIWO1-LaborSummary',!Projects,!Employees_ASDF, DB('Labor-ASDF',!Employees_ASDF,!Months,!Projects,'Forecast','PLC') ,!Months,!Versions, attrs ( 'Employees_ASDF' , !Employees_ASDF, 'EmplGroup' ), 'Cost');
Target Cube	dimensions	Rule
SumCostIWO1-LaborSummary	Projects Employees_ASDF PLC Months Versions Companies Labor Calcs	Code: Select all ['Hours'] = if ( attrs( 'Versions', 'Forecast', 'LiveVersion') @='Y' & !Companies @= attrs ( 'Employees_ASDF' , !Employees_ASDF, 'EmplGroup' )& !PLC @= DB('Labor-ASDF',!Employees_ASDF,!Months,!Projects,!Versions,'PLC'), DB('Labor-ASDF',!Employees_ASDF,!Months,!Projects,!Versions,'Hours'), CONTINUE ); ['Cost'] = if ( attrs( 'Versions', 'Forecast', 'LiveVersion') @='Y' & !Companies @= attrs ( 'Employees_ASDF' , !Employees_ASDF, 'EmplGroup' )& !PLC @= DB('Labor-ASDF',!Employees_ASDF,!Months,!Projects,!Versions,'PLC'), DB('Labor-ASDF',!Employees_ASDF,!Months,!Projects,!Versions,'Cost'), CONTINUE );

Thanks,
Paul.

[Elessar]

Hello!
That's a very well structured question!

I assume the cause here is that after Employees_ASDF attribute or "DB('Labor-ASDF',!Employees_ASDF,!Months,!Projects,!Versions,'PLC')" changes, rule uses new value, but feeder remains in the old value. Feeder fires once when rule is saved or when value is entered to source cell. But it does not know if anything changes in attributes or cell values used in DB.

You can also refer to question #7 in my quiz viewtopic.php?p=83204#p83204

#tm1forumalive

[Paul-TM1]

Hi Elessar,
Thanks for the reply.
I understood that the PLC should also be fed and have added another feeder as below and refreshed the feeders and it did not help.

Code: Select all

['PLC'] =>DB('SumCostIWO1-LaborSummary',!Projects,!Employees_ASDF,  
	DB('Labor-ASDF',!Employees_ASDF,!Months,!Projects,'Forecast','PLC') ,!Months,!Versions,
		attrs ( 'Employees_ASDF' ,  !Employees_ASDF, 'EmplGroup' ),'PLC') ;

Thanks,
Paul.

[Paul-TM1]

Found the issue. I have hard coded the version in the feeder.

Code: Select all

DB('Labor-ASDF',!Employees_ASDF,!Months,!Projects,'Forecast','PLC')

Thanks,
Paul

[MarenC]

Hi,

Would have been good if this:

For some reason, it's not working for a few elements

was this:

For some reason, it's not working for a few versions!

But good that you told us the problem and managed to resolve it.

Maren