Share via


Configuring Database Dimension Properties

In Microsoft SQL Server 2005 Analysis Services (SSAS), the characteristics of a dimension are defined by the metadata for the dimension, based on the settings of various dimension properties, and on the attributes or hierarchies that are contained by the dimension. The following table describes the dimension properties in Analysis Services.

Property Description

AttributeAllMemberName

Specifies the name of the All member for attributes in a dimension.

Collation

Determines the collation used by the dimension.

CurrentStorageMode

Contains the current storage mode for the dimension.

DependsOnDimension

Contains the ID of another dimension on which the dimension depends, if any.

Description

Contains the description of the dimension.

ErrorConfiguration

Configurable error handling settings for handling of duplicate keys, unknown keys, error limits, action upon error detection, error log file, and null key handling.

ID

Contains the unique identifier (ID) of the dimension.

Language

Specifies the default language for the dimension.

MdxMissingMemberMode

Determines how missing members are handled for Multidimensional Expressions (MDX) statements.

MiningModelID

Contains the ID of the mining model with which the data mining dimension is associated. This property is applicable only if the dimension is a mining model dimension.

Name

Specifies the name of the dimension.

ProactiveCaching

Defines the proactive cache settings for the dimension.

ProcessingGroup

Specifies the processing group. Values are ByAttribute or ByTable. Default is ByAttribute.

ProcessingMode

Indicates whether Analysis Services should index and aggregate during or after processing.

ProcessingPriority

Determines the processing priority of the dimension during background operations such as lazy aggregation, indexing, or clustering.

Source

Identifies the data source view to which the dimension is bound.

StorageMode

Determines the storage mode for the dimension.

Type

Specifies the type of the dimension.

UnknownMember

Indicates whether the unknown member is visible.

UnknownMemberName

Specifies the caption, in the default language of the dimension, for the unknown member of the dimension.

WriteEnabled

Indicates whether dimension writebacks are available (subject to security permissions).

Note

For more information about setting values for the ErrorConfiguration and UnknownMember properties when working with null values and other data integrity issues, see Handling Data Integrity Issues in Analysis Services 2005.

See Also

Concepts

Attributes and Attribute Hierarchies
User-Defined Hierarchies
Dimension Relationships
Dimensions (Analysis Services)

Help and Information

Getting SQL Server 2005 Assistance