Dimension Checks (PDM)

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

Check

Description and Correction

Dimension name and code uniqueness

Dimension 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

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