Validating the model
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.
OR
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.