Chapter 9 Working with Data Models
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 |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |