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