Page 1 of 1
Help with a Feeder
Posted: Thu Feb 12, 2026 3:55 pm
by 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.
Re: Help with a Feeder
Posted: Thu Feb 12, 2026 4:33 pm
by 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
Re: Help with a Feeder
Posted: Thu Feb 12, 2026 5:01 pm
by 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.
Re: Help with a Feeder
Posted: Thu Feb 12, 2026 9:20 pm
by 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