The first statement, which brings values into the Depletion cube from the FishRequired cube, demands a feeder in the rule for the FishRequired cube.
['Total Fish Cake Types','Qty Required - Kgs']=>DB('Depletion',
!fishtype,!date,'6','Required');
You can easily invert the statement to construct the following feeder:
This feeder says that whenever there is a value for Qty Required - Kgs for Total Fish CakeTypes, feed cells in the Depletion cube identified by 6 and Required.
Follow the steps below to add this statement to the rule for the FishRequired cube.
Procedure
-
Double-click the FishRequired rule in Server Explorer.
-
Insert a FEEDERS; declaration on a line below the existing rule statement in the Rules Editor.
-
Add the following statement immediately following the FEEDERS; declaration.
['Total Fish Cake Types','Qty Required - Kgs']=>DB('Depletion',!fishtype,
!date,'6','Required');
The FishRequired rule should now appear as follows:
SKIPCHECK;
['Qty Required - Kgs']=N:DB('Production',!CakeType,!Date,'Quantity
Produced - Kgs')*DB('Ingredients',!CakeType,!FishType);
FEEDERS;
['Total Fish Cake Types','Qty Required - Kgs']=>DB('Depletion',
!fishtype,!date,'6','Required');
-
Click Save to save the Fish Required rule.