Validating data modules

Use the validation feature to check for invalid object references within a data module.

About this task

Validation identifies the following errors:

  • A table or column that a data module is based on no longer exists in the source.
  • A calculation expression is invalid.
  • A filter references a column that no longer exists in the data module.
  • A table or column that is referenced in a join no longer exists in the data module.

Errors in the data module are identified by the failed validation icon .

Procedure

  1. In the data module tree, click the data module context menu icon , and click Validate

    If errors are identified, the failed validation icon is displayed in the data module tree, in the diagram, and in the properties panel, next to the column or expression where the error exists. The descriptions of errors are displayed in the validation view.

    Tip: To open the validation view, click its icon .
  2. Click the failed validation icon for a module, column, expression, or join to view a pop-up box that informs you of the number of errors for the selected item. Double-click the failed validation icon in the pop-up box to view the error details.

Results

Using the validation messages, try to resolve the errors. You can save a data module with validation errors in it.