Add an Assignment Rule to a Transaction Table Group

  1. Activate the Rules workspace, and select a model.


  2. Select File Add Assignment Rule (or click the Add Assignment Rule icon ).


  3. Name the rule.
  4. Select the transaction table group to which you want to assign the rule.


  5. Click Define to specify selection criteria.


  6. Specify selection criteria to filter the rows in a transaction table group to include in a calculation.

    To specify selection criteria:
    1. Select a column in the transaction table.
    2. Select an operator to apply to the selected column:

      If the selected column is: You can use the following operators:
      Text =, not =
      match Behavior
      Numeric =, not =, <, <=, >, >=
      match Behavior
      Dimension is child of
      match Behavior
    3. Select a value to compare the column to.
    4. Click Add New Row to add another condition to the selection criteria.

      Note: If you are using the match Behavior operator, then each condition must be joined with the And operator.

    5. Click OK.

  7. Select one or more numeric columns to use in the driver formula.

    The driver formula can be any of the following:

    Formula: Example:
    Single numeric property AMT
    Multiple numeric properties (COUNT * .05) + (AMT * .01)
    Single entered value 15
    SAS numeric expression

    MAX(Requests, Complaints)*.25

    EUROCURR(AMT,'eur','frf')

    IF CustID ='C00650' THEN (0.54*Distance)
    ELSE IF CustID ='C00692' THEN (0.74*Distance)
    ELSE (0.23*Distance)

  8. Click OK.



    The added rule displays in the Rules workspace under the transaction table group to which the rule belongs.