Dimension in cube table
The
DEPM_MOD_DIMENSIONINCUBE table indicates what dimensions belong to a particular cube.
| Name | Definition |
|---|---|
| CubeID | nvarchar(50) NOT NULL; PK |
| DimensionID | nvarchar(50) NOT NULL; PK |
| Order | int NOT NULL; unique key |
Order defines the order of dimensions in the cube.
The table has these references:
| Source columns | Target table | Target columns |
|---|---|---|
| CubeID | _cube | ID |
| DimensionID | _dimension | ID |
Note: Do not include the Roles dimension (#_GRP_) in this table. #_GRP_ is a system dimension and is included automatically when the access cube is published.