Once you have generated the model, you can easily check that it is valid. For example, for a model to be valid, each of the tables must have a Business Key.
Validating the model does not recalculate expressions for historical data that has changed. Changes in a dimension expression or lookup of a column in a dimension are not updated retroactively. In order to update historical data, you would need to reload the data which could take a long time depending on the number of records and their history.
To validate the model:
Either click the Validate button in the bottom right of the Model panel.
Select Validate from the drop-down menu in the top right of the Model panel.
The Validate Model window opens.
If the model is valid, a message will confirm the model’s validity. If the model is not valid, a list of invalid tables/views will be displayed.
A message indicating why the entity is invalid will be displayed in the Message column.
To resolve the issue, click the Edit Entities button to the right of the entity.
The Edit Model window opens showing the invalid entity.
Resolve the issue (in this case, by adding a Business Key) and then click Close.
A message will confirm the model’s validity.
- Click Close to close the Validate Model window.