PowerDesigner provides default model checks to verify the validity of dimensions.
Check |
Description and Correction |
---|---|
Name/Code contains terms not in glossary |
[if glossary enabled] Names and codes must contain only approved terms drawn from the glossary.
|
Name/Code contains synonyms of glossary terms |
[if glossary enabled] Names and codes must not contain synonyms of glossary terms.
|
Name/Code uniqueness |
Object names must be unique in the namespace.
|
Existence of attribute |
A dimension must have at least one attribute.
|
Existence of hierarchy |
A dimension must use at least one hierarchy.
|
Dimension have duplicated hierarchies |
Dimensions should not have duplicated hierarchies, that is to say hierarchies organizing identical attributes.
|
Dimension without a default hierarchy |
A dimension should have a default hierarchy.
|
Dimension mapping not defined |
A dimension should be mapped to tables or views in an operational model in order to be populated by data from this model.
|
Attribute mapping not defined |
Attributes must be mapped to columns in the data source tables or views.
|
Incomplete dimension mapping for multidimensional generation |
All attributes, detail attributes and hierarchies of the dimension must be mapped to tables and columns. You must map the dimension objects before generation.
|