Defining 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 2005 Analysis Services (SSAS). This property can have the following values:
Value
Description
FullEvery aggregation for the cube must include the All member.
NoneNo aggregation for the cube can include the All member. This is the default value.
UnrestrictedNo restrictions are placed on the Aggregation Designer.
DefaultThe same functionality as Unrestricted.
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:
Value
Description
IncludeDimensionNameThe name of the dimension is included as part of the name of the hierarchy. This is the default value.
ExcludeDimensionNameThe name of the dimension is not included as part of the name of the hierarchy.
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:
Value
Description
Native Analysis Services automatically determines the unique names of members. This is the default value.
NamePath Analysis Services generates a compound name consisting of the name of each level and the caption of the member.
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.
See Also
Concepts
Dimensions (Analysis Services)