Share via

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


Completed projects for all of the lessons in this tutorial are available online. You can jump ahead to any lesson by using the completed project from the previous lesson as a starting point. Click here to download the sample projects that go with this tutorial.

This lesson contains the following tasks:

Next Lesson

Lesson 6: Defining Calculations

See Also


Analysis Services Tutorial Scenario

Multidimensional Modeling (Adventure Works Tutorial)

Dimension Relationships

Other Resources

Defining Dimension Usage Relationships