Feeding the Depletion Process

After you have the depletion model working, you must add SKIPCHECK and FEEDERS statements to optimize the performance of the model.

First, you must add a SKIPCHECK statement to the beginning of the rule for the Depletion cube.

Procedure

  1. Double-click the Depletion rule in Server Explorer.
  2. Insert the SKIPCHECK; statement on the first line of the Rules Editor.
  3. Click Save.

    Recall that the rule for the Depletion cube is comprised of the following statements:

    ['6','Required']=DB('FishRequired','Total Fish Cake Types',!FishType,!Date,'Qty
Required - Kgs');
    ['Available']=DB('Inventory',!FishType,!Date,!DaysOld,'Quantity
in
Stock - Kgs');
    ['Used']=N:IF(['Available'] >= ['Required'], ['Required'], ['Available']);
    ['Required']=N:DB('Depletion',!FishType,!Date,DNEXT('DaysOld',!DaysOld),'Still
Required');