TM1 Forum

Hi All,

we have a rule (part of which is below) which is based on conditions. Are feeders required for this rule, given that the conditions allways need to be evaluated when displaying/consolidating values?

thanks,

Gregory

[{ 'Scenario 1', 'Scenario 2', 'Working Weekly', 'Weekly Adjustment'},'IFO','Consumption'] = N:
#Bunker 1
IF(!Year @= DB('Voyage Profile',!Version,!Service,!Direction,!Schedule,'Year') & !Month @= DB('Voyage Profile',!Version,!Service,!Direction,!Schedule,'Month') &
!POD @= DB('Vessel Schedule',!Version,!Service,!Direction,ATTRS('Schedule', !Schedule, 'Vessel'),
DB('Voyage Assumption',!Version,!Service,!Direction,ATTRS('Schedule', !Schedule, 'Vessel'), ATTRS('Schedule', !Schedule, 'Voyage'),'Rotation')
,'Bunker 1','Port'),
DB('Voyage Assumption',!Version,!Service,!Direction,ATTRS('Schedule', !Schedule, 'Vessel'), ATTRS('Schedule', !Schedule, 'Voyage'),'IFO Total')
,0)*
(DB('Vessel Schedule',!Version,!Service,!Direction,ATTRS('Schedule', !Schedule, 'Vessel'),
DB('Voyage Assumption',!Version,!Service,!Direction,ATTRS('Schedule', !Schedule, 'Vessel'), ATTRS('Schedule', !Schedule, 'Voyage'),'Rotation')
,'Bunker 1','IFO Percentage') \
DB('Vessel Schedule',!Version,!Service,!Direction,ATTRS('Schedule', !Schedule, 'Vessel'),
DB('Voyage Assumption',!Version,!Service,!Direction,ATTRS('Schedule', !Schedule, 'Vessel'), ATTRS('Schedule', !Schedule, 'Voyage'),'Rotation')
,'All Bunker','IFO Percentage'))
+
etc. ( - similar for Bunkers 2 & 3.)

On further investigation it seems the answer is YES - feeders are required.
(The consolidations weren't working until a feeder was added).