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.