Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 239

When a dimension is related to the fact data through another dimension, you
define this dimension as having a reference relationship with the measure
group. You might recall that you added the Dim Geography dimension in the
Review Shared Dimension page of the Cube Wizard. However the Cube Wiz-
ard was not smart enough to figure out there is a relationship between the
Fact tables and the Dim Geography dimension table through other dimension
tables. Hence the Cube Wizard did not add the Dim Geography dimension as
a cube dimension. Since the relationship between the Dim Geography dimen-
sion and the measure groups in the Adventure Works DW are through anoth-
er dimension you can say that there is an indirect relationship between Dim
Geography dimension and the measure groups. This indirect relationship
between the measure groups and dimensions is called a reference relation-
ship.
Follow the steps below to add the Dim Geography dimension to the cube and
establish the reference relationship:
1. To add the Dim Geography database dimension to the cube, right-
click in the Dimension pane of the Cube Structure tab and select Add
Cube Dimension, as shown in Figure 6-15 .