Target Design

Add a Basic Rule to a Target Field

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-field level, the user selects the rule to apply to the selected field.

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

To add a Basic rule to a target field in Target Design:

  1. Select Design in the Navigation pane.
  2. Click the Targetsicon on the Design page.
  3. Select the Fields icon for a Target.
  4. Click the Basic Rules icon for a field.

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

    View the field descriptions for the Rules: Basic Rule page

  6. Enter a value in the PRIORITY field.

    NOTE: This is the order that the Basic rule will be added to the enrichment data flow when the rule is autogenerated during Data Services AutoGen if multiple rules are added for the field. This number must be unique.

  7. Enter a descriptive rule name in the NAME field.
  8. Click Save; the Vertical View displays.
  9. 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.

  10. Enable the Is Null Condition check box if needed.

    NOTE: If enabled, 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.

  11. 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 field. Each field can only be used in one condition per rule.

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

    NOTE: Up to three conditions can be added.

    NOTE: Use single quotes (‘) around strings.

  13. 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 Rule page'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.