Target Design

Add a Basic Rule to a Target

A Basic rule allows a user to create a simple conditional or default rule (one that populates the field with a default value).

Basic rules are logic conditions associated with a Target field that are used in Data Services AutoGen. When Data Services AutoGen  runs, the Basic rules are added to the job in the enrichment data flow based on the priority set in Target Design.

Refer to Data Services AutoGen for more information.

When a Basic rule is added at the Target level, the user selects the field to which the rule is applied.

NOTE: Use single quotes (‘) around strings when entering values.

To assign a Basic rule to a field at the Target level:

  1. Select Design in the Context bar.
  2. Click the Targets icon.
  3. Click the Basic Rules icon for a Target.

    NOTE:: If no records exist, the page displays in add mode. Otherwise, click Add.

    View the field descriptions for the Rules: Basic Rule page

  4. Select the field to which the rule applies in the TARGET FIELD ID list box.

    NOTE: Only active fields assigned to the selected Target display.

    NOTE: zLegacy fields do not display and fields that are in field groups other than the default field group (*);do not display.

  5. Enter a value in the PRIORITY field.

    NOTE: This is the order that the Basic rule will be added to the enrichment data flow during Data Services AutoGen if multiple rules are added for the field. This number must be unique for a rule / field combination (as in, a rule for another Target field can have the same priority number but cannot use the same Target field).

  6. Enter a descriptive rule name in the NAMEfield.
  7. Click Save; the Vertical View displays.
  8. Enter a value in the Field Value field.

    NOTE: This is the value that the field will be set to if the rule condition(s) is met.

    NOTE: Use single quotes (‘) around strings.

  9. Check the Is Null Condition check box if needed.

    NOTE: If checked, if the value in the Target field is NULL, the field will be populated with the value in the Field Value field. The Is Null Condition works in conjunction with any other rule condition added for the Target field.

  10. Select a field name in the Rule Field1 list box.

    NOTE: The values stored in this field in the Target are evaluated using the value entered in the Rule Field1Value. Each field can only be used in one condition per rule.

  11. Enter the value that will cause Field Value to be set for the field in the RuleField1Value field.

    NOTE: Up to three conditions can be added. They will be AND combined.

    NOTE: Use single quotes (‘) around strings.

  12. Click Save.

For example, a user sets a Basic rule for the PSTAT field (Maintenance Status) on the ttMARA table by completing the fields on the Rules: Basic Rulepage's Vertical View with these values.

Field

Value

Field Value

1

Rule Field1

MTART

Rule Field1 Value

FERT

This rule states that if the MTART field (Material Type) on the ttMARA table has a value of FERT (Finished Goods), the rule condition is met, and the PSTAT field for that record will be set to 1.