Defining Dimension Usage 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.

Note

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 and Referenced Relationship Properties

• Defining a Fact Relationship and Fact Relationship Properties

• Defining a Many-to-Many Relationship and Many-to-Many Relationship Properties

See Also

Concepts

Designing Cubes