SQL Server
United States - English
Home
2012
2008 R2
2008
2005
2000
Library
Forums
0 out of 2 rated this helpful - Rate this topic

Defining Cube Dimension Properties

SQL Server 2005

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:

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.
Value Description

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:

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.
Value Description

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:

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.
Value Description

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.

Concepts

Dimensions (Analysis Services)

Help and Information

Getting SQL Server 2005 Assistance
Did you find this helpful?
(1500 characters remaining)
Community Content Add
Annotations FAQ