Skip to main content
Version: I2023.3.0

About the Model Validator

The Model Validator detects errors as you model the hierarchies and levels of dimensions in a cube.

Dimension hierarchies are validated when:

  • You open the canvas for that dimension.
  • You edit a dimension hierarchy.

Validation is dependent on the collection of statistics for the underlying table columns. Therefore, hierarchy levels can initially be in an unknown state, but will transition to Good, Error, or Warning once statistics are available.

Hierarchy level states are indicated by flags next to them in the Design Center. The states can be:

  • Unknown (black flag)
  • Good (green flag)
  • Warning (orange flag)
  • Error (red flag)

A Validation panel appears at the bottom of the Cube Designer window, and Errors and Warning tabs display the validation results. You can expand and contract the panel using the angle controls at the right. Each error is summarized. You can expand the error message using the angle controls. Click Fix This to display the Level dialog box to correct the problem.

image

Opening the Hierarchies panel for the dimension shows a flag next to each level indicated the level's status, and the Level dialog box shows the complete error message next to the field with the problem that needs correction:

image

note

Note: There may be more than one way to resolve a model validation error. For example, if AtScale identifies a specific hierarchy level as using a duplicate key, the solution preferred by your data architect may be to change the key used in a different hierarchy level.

Model Validation Errors and Examples

MessageApplies ToExample
Child key value points to multiple parent key valuesLevel in a hierarchyA dimension using dim_geo_state is present. The first level will be state with a key and name column of state. The child level will be country where the key and name column are country. The child level (united states) will point to 50 parent states, producing an incorrect result.
Level key points to multiple namesLevel in a hierarchyA geography dimension using dim_geo_state is present. The one level will have key column of country and name column of state, producing an incorrect result.
Key value points to multiple secondary attributesKey value on secondary attributesA geography dimension using dim_geo_state is present. The one level will have key column of country and a name column of state. A secondary attribute is added with a key column of country and a name column of state producing an incorrect result.
Key value points to multiple sort valuesSorting on a level in a hierarchyA geography dimension using dim_geo_state is present. The one level present has a key and name column of country and a sort column of state, producing an incorrect result.
Column's uniqueness flag is incorrectKey and value columns on a levelA customer dimension using dim_customer is present with both the key and value columns set to lastname. Selecting Contains Unique Names beneath the keys will produce incorrect results because there are duplicate last names.
Attribute's Contain Unique Names field is incorrectLevel in a hierarchyA customer dimension using dim_customer is present with both the key and value columns set to lastname. Enabling Contains Unique Names on the dimension's only level will produce incorrect results.
Key can only be used once in this hierarchyHierarchy in a dimensionA date dimension using dim_date is present with the year and month key columns set to year. This produces an incorrect result.

Model Validation Errors and Descriptions

MessageApplies ToDescription
Child key value points to multiple parent key valuesLevel in a hierarchyA child key value cannot point to multiple parent key values.
Level key points to multiple namesLevel in a hierarchyA hierarchy level's key points to multiple names.
Key value points to multiple secondary attributesKey value on secondary attributesA hierarchy level's key value points to multiple secondary attributes.
Key value points to multiple sort valuesSorting on a level in a hierarchyAn attribute's key value points to multiple sort values.
Column's uniqueness flag is incorrectKey and value columns on a levelThe column's uniqueness flag is incorrect. Either there are duplicate key values in the columns, or the uniqueness flag is not selected but could be because no duplicate key values are found.
Attribute's Contain Unique Names field is incorrectLevel in a hierarchyThe attribute's Contains Unique Names field is incorrect. Either duplicate names are detected for a key, or Contains Unique Names is not selected but could be because no duplicate names are found.
Key can only be used once in this hierarchyHierarchy in a dimensionTwo levels in a hierarchy cannot use the same key.