Cube Checks (PDM)

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

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 association

A cube must have at least one association with a dimension.
  • Manual correction: Create an association between the cube and a dimension

  • Automatic correction: None

Existence of fact

A cube must be associated to a fact.
  • Manual correction: Click the Ellipsis button beside the Fact box in the cube property sheet, and select a fact from the List of Facts

  • Automatic correction: None

Duplicated association with the same dimension

A cube cannot have more than one association with the same dimension.
  • Manual correction: Delete one of the associations

  • Automatic correction: None