Defining and Configuring Dimension Usage and Dimension Relationships
You define and configure dimension usage and dimension relationships on the Dimension Usage tab in Business Intelligence Development Studio. Dimension usage defines how cube dimensions are used, if at all, within each measure group. Dimension relationships define how the cube dimensions used in a measure group relate to the measures in the measure group.
For more information about performance issues related to cube design, see the SQL Server 2005 Analysis Services Performance Guide.
In this Section
- Defining a Regular Relationship and Regular Relationship Properties
- Defining a Referenced Relationship
- Defining a Fact Relationship and Fact Relationship Properties
- Defining a Many-to-Many Relationship and Many-to-Many Relationship Properties