Define Cube Dimension Properties
A cube dimension is an instance of a database dimension within a cube. A database dimension can be used in multiple cubes, and multiple cube dimensions can be based on a single database dimension. The following table describes the properties of a cube dimension.
Property |
Description |
||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
AllMemberAggregationUsage |
Controls how aggregations are designed by the Aggregation Designer in Microsoft SQL Server Analysis Services. This property can have the following values:
|
||||||||||
Description |
Provides a descriptive name for the level. |
||||||||||
DimensionID |
Contains the unique identifier (ID) of the database dimension. |
||||||||||
HierarchyUniqueNameStyle |
Determines how unique names are generated for hierarchies that are contained within the cube dimension. This property can have the following values:
|
||||||||||
ID |
Contains the unique identifier of the cube dimension. |
||||||||||
MemberUniqueNameStyle |
Determines how unique names are generated for members of hierarchies contained within the cube dimension. This property can have the following values:
|
||||||||||
Name |
Contains the friendly name of the cube dimension. By default, the name of a cube dimension is the same as the name of the database dimension, unless another cube dimension of the same name is already defined. |
||||||||||
Visible |
Determines whether the cube dimension is visible. The default value is True. |