Dimension Checks (PDM)

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.
  • 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

A dimension must have at least one attribute.
  • Manual correction: Create an attribute in the Attributes tab of the dimension property sheet

  • Automatic correction: None

Existence of hierarchy

A dimension must use at least one hierarchy.
  • Manual correction: Create a hierarchy in the Hierarchies tab of the dimension property sheet

  • Automatic correction: None

Dimension have duplicated hierarchies

Dimensions should not have duplicated hierarchies, that is to say hierarchies organizing identical attributes.
  • Manual correction: Remove one of the duplicated hierarchies

  • Automatic correction: None

Dimension without a default hierarchy

A dimension should have a default hierarchy.
  • Manual correction: Select a hierarchy in the Default Hierarchy list of the dimension property sheet

  • Automatic correction: None

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.
  • Manual correction: Map the dimension to a table or a view. You may need to create a data source before you can create the mapping

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

Attribute mapping not defined

Attributes must be mapped to columns in the data source tables or views.
  • Manual correction: Map the attributes to columns in the data source

  • Automatic correction: None

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.
  • Manual correction: Map dimension objects to tables and columns

  • Automatic correction: None