Cube Checks (PDM)

The following PDM model checks are made on 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


Created October 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com