Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In Microsoft SQL Server 2005 Analysis Services (SSAS), 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 |
|---|---|
Provides an overview of dimension concepts. |
|
Describes attributes and attribute hierarchies. |
|
Describes user-defined hierarchies of attributes. |
|
Describes write-enabled dimensions. |
|
Describes translations of dimension meta data. |
Defining and Configuring Dimensions, Attributes, and Hierarchies
Cubes (Analysis Services)
Unified Dimensional Model