Creating the Calculation Statement for Qty Required - Kgs

Follow the steps below to create this calculation statement in the rule for the FishRequired cube.

Procedure

  1. Right-click the FishRequired cube in the Server Explorer and click Create Rule.

    The Rules Editor opens.

  2. Enter the calculation statement on the first line of the Rules Editor.
  3. Click Save to save the rule.

    If the TM1® server receives a request for the quantity (in Kgs) of flounder required to make Surf Platter fish cakes on January 20th, the rule calculates as follows.

    Image showing a rule calculation.
  4. Open the Flounder required - Jan 20 view of the Fish Required cube to confirm that the statement calculates Qty Required - Kgs values.