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 |