Fact Measure, Dimension Hierarchy, and Attribute Checks (PDM)

PowerDesigner provides default model checks to verify the validity of fact measures, dimension hierarchies, and fact and dimension 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.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - None.

Name/Code contains synonyms of glossary terms

[if glossary enabled] Names and codes must not contain synonyms of glossary terms.
  • Manual correction - Modify the name or code to contain only glossary terms.
  • Automatic correction - Replaces synonyms with their associated glossary terms.

Name/Code uniqueness

Object names must be unique in the namespace.
  • Manual correction - Modify the duplicate name or code.
  • Automatic correction - Appends a number to the duplicate name or 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