Feeding the First Statement

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

  1. Double-click the FishRequired rule in Server Explorer.
  2. Insert a FEEDERS; declaration on a line below the existing rule statement in the Rules Editor.
  3. 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');
  4. Click Save to save the Fish Required rule.