PowerDesigner provides default model checks to verify the validity of fact measures and dimension hierarchies and attributes.
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 |
[hierarchies only] A dimension hierarchy must have at least one attribute.
|