Export (0) Print
Expand All

Dimensions (Analysis Services - Multidimensional Data)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

In Microsoft SQL Server Analysis Services, dimensions are a fundamental component of cubes. Dimensions organize data with relation to an area of interest, such as customers, stores, or employees, to users. Dimensions in Analysis Services contain attributes that correspond to columns in dimension tables. These attributes appear as attribute hierarchies and can be organized into user-defined hierarchies, or can be defined as parent-child hierarchies based on columns in the underlying dimension table. Hierarchies are used to organize measures that are contained in a cube. The following topics provide an overview of dimensions, attributes, and hierarchies.

Topic

Description

Introduction to Dimensions (Analysis Services - Multidimensional Data)

Provides an overview of dimension concepts.

Attributes and Attribute Hierarchies

Describes attributes and attribute hierarchies.

User Hierarchies

Describes user-defined hierarchies of attributes.

Write-Enabled Dimensions

Describes write-enabled dimensions.

Dimension Translations

Describes translations of dimension meta data.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft