_CubesDimensions
The _CubesDimensions table lists the name and properties of a cube, including cube type. This table also includes cube rules as XML fragments. One XML fragment is provided per cube. It can contain multiple rules.
This table describes _CubesDimensions:
| Column | Type | Description |
|---|---|---|
| CubeName | String(50) | Name of cube. |
| DimensionName | String(50) | Name of dimension of the cube whose name is CubeName. |
| DimensionOrder | Integer | The position of the dimension as it is ordered in the cube. |
| MeasureDimension | Boolean | Flag for whether
the dimension is a measure dimension or not:
Caution: More than one measure dimension on a cube is
not permitted. It is the responsibility of the user to ensure that not more
than one dimension of a cube is flagged as a measure dimension.
|
| Comment | Text | User defined comment. |
General information
For each cube there are as many rows as there are dimensions.