Creating the Feeder Statement for Qty Required - Kgs

Follow the steps below to add this feeder to the rules for the Production cube.

Procedure

  1. Double-click the FishRequired rule in Server Explorer.
  2. Insert a SKIPCHECK; declaration immediately before the existing calculation statement in the rule.
  3. Click Save to save the rule and exit the Rules Editor.
  4. Double-click the Production rule in Server Explorer.
  5. Click Edit Rule.

    The Rules Editor opens. The rules for the Production cube already contain a feeder statement that feeds the Plan cube.

  6. Enter the feeder statement on a new line following the existing feeder statement.

    The feeders for the Production rule should now appear as follows.

    FEEDERS;
    ['Quantity Produced - Kgs']=>DB('Plan',!CakeType,!Date,'Planned
Production
Qty - Kgs');
    ['Quantity Produced - Kgs']=>DB('FishRequired',!CakeType,'Total
Fish
Types',!Date,'Qty Required - Kgs')'
  7. Click Save to save the Production rule.

    This new feeder overfeeds the FishType dimension, because feeding Total also feeds all FishTypes elements for every CakeType produced on a given date. This is not uncommon when feeding from one cube to another, because the dimensionality of the target cube is typically greater than that of the source cube. In this example, the target cube FishRequired has the additional FishType dimension that is not part of the Production cube. In such a situation, overfeeding is inevitable.