Lesson 5: Defining Relationships Between Dimensions and Measure Groups

In the previous lessons in this tutorial, you learned that database dimensions added to a cube can be used as the basis for one or more cube dimensions. In this lesson, you learn to define different types of relationships between cube dimensions and measure groups, and to specify the properties of these relationships.

For more information, see Dimension Relationships, and Defining and Configuring Dimension Usage and Dimension Relationships.


A completed project through Lesson 4 is available by downloading and installing the updated samples. For more information, see Obtaining Updated Samples in Installing Samples.

This lesson contains the following tasks:

Next Lesson

Lesson 6: Defining Calculations

See Also


Analysis Services Tutorial Scenario
SQL Server 2005 Analysis Services Tutorial

Other Resources

Dimension Relationships
Defining and Configuring Dimension Usage and Dimension Relationships

Help and Information

Getting SQL Server 2005 Assistance