Fact Checks (PDM)

PowerDesigner provides default model checks to verify the validity of facts.

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 measure

A fact must have at least one measure.

  • Manual correction: Create a measure in the Measures tab of the fact property sheet

  • Automatic correction: None

Fact mapping not defined

A fact must be mapped to tables or views in an operational model in order to be populated by data from this model.

  • Manual correction: Map the fact to tables or views. You may need to create a data source before you can create the mapping

  • Automatic correction: Destroys the mapping for the fact. This removes the data source from the Mapping list in the fact Mapping tab

Measure mapping not defined

Fact measures must be mapped to columns in the data source tables or views.

  • Manual correction: Map the fact measure to columns in the data source

  • Automatic correction: Destroys the mapping for the measure. This removes the measures that are not mapped to any object in the Measures Mapping tab of the fact Mapping tab