Dimensions (Analysis Services - Multidimensional Data)
Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium
In Microsoft SQL Server 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 SQL Server 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.
In This Section
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. |
See Also
Dimensions in Multidimensional Models
Cube Objects (Analysis Services - Multidimensional Data)