DataSet Editing Design Tips

The following design tips provide methods in which you can optimize dataset performance:

  • Specify the correct data type (generally String, Float, or Integer) when creating derived attributes. The most common mistake is to specify a number as a string; using string comparisons, 100 is less than 99.
  • Specify a valid dataset key that uniquely identifies each record in the dataset; end the name with SEQ_ID. If the dataset generates matches that display as building blocks, use one of the key attributes for the dataset key.
  • Avoid creating any derived attribute that can cause a divide by zero error.
  • Filter out null values in the fields that you want to use in the pattern.
  • Never allow a null focal entity key.

for more information about scenario design tips and guidelines, see Scenario Design Guidelines.