Chapter 9 Working with Data Models
The following PDM model checks are made on 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 |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |