Define Cube Dimension Properties

 

Applies To: SQL Server 2016

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.

PropertyDescription
AllMemberAggregationUsageControls how aggregations are designed by the Aggregation Designer in Microsoft SQL Server Analysis Services. This property can have the following values:

 Full: Every aggregation for the cube must include the All member.

 None: No aggregation for the cube can include the All member. This is the default value.

 Unrestricted: No restrictions are placed on the Aggregation Designer.

 Default: The same functionality as Unrestricted.
DescriptionProvides a descriptive name for the level.
DimensionIDContains the unique identifier (ID) of the database dimension.
HierarchyUniqueNameStyleDetermines how unique names are generated for hierarchies that are contained within the cube dimension. This property can have the following values:

 IncludeDimensionName:
The name of the dimension is included as part of the name of the hierarchy. This is the default value.

 ExcludeDimensionName:
The name of the dimension is not included as part of the name of the hierarchy.
IDContains the unique identifier of the cube dimension.
MemberUniqueNameStyleDetermines how unique names are generated for members of hierarchies contained within the cube dimension. This property can have the following values:

 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.
NameContains 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.
VisibleDetermines whether the cube dimension is visible. The default value is True.

Dimensions (Analysis Services - Multidimensional Data)

Community Additions

ADD
Show: