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 |