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.)
Feeders required for Conditional Rule?
-
- Posts: 51
- Joined: Thu Aug 06, 2009 11:09 pm
- OLAP Product: TM1
- Version: 10.2.20100.123
- Excel Version: 365
- Location: Sydney
Re: Feeders required for Conditional Rule?
On further investigation it seems the answer is YES - feeders are required.
(The consolidations weren't working until a feeder was added).
(The consolidations weren't working until a feeder was added).