Cube Checks (PDM)

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