define-cube-dimension-properties.md

title	Define Cube Dimension Properties | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	analysis-services
ms.topic	conceptual
helpviewer_keywords	dimensions [Analysis Services], characteristics properties [Analysis Services], dimensions
ms.assetid	9314e749-0918-4862-abaf-a21692188122
author	minewiskan
ms.author	owend
manager	craigg

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 [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion]. 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.
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.
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: [!INCLUDEssASnoversion] automatically determines the unique names of members. This is the default value. NamePath: [!INCLUDEssASnoversion] 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

Dimensions (Analysis Services - Multidimensional Data)