PowerDesigner provides default model checks to verify the validity of fact measures and dimension hierarchies and attributes.
|
Check |
Description and Correction |
|---|---|
|
Name and code uniqueness |
Names and codes must be unique in the model. Manual correction: Modify the duplicate name/code Automatic correction: Appends a number to the duplicate name/code |
|
Existence of attribute |
[hierarchies only] A dimension hierarchy must have at least one attribute. Manual correction: Add an attribute to the hierarchy from the Attributes tab of the hierarchy property sheet Automatic correction: None |