PowerDesigner provides default model checks to verify the validity of cubes.
Check |
Description and Correction |
---|---|
Cube name and code uniqueness |
Cubes 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 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 |