Database Reference
In-Depth Information
The grid displays dimensions on the left side of the window and measure groups across the top. Each
intersecting cell represents a relationship. Cells that are grayed out indicate that there is no relationship defined
between that measure group and that particular dimension. In Figure
11-23
, you can see that the DimStores
dimension is related to the FactSales measure group based on the Store attribute. But it is not related to the other
fact table, FactTitleAuthors. This is indicated by the cell beneath the FactTitleAuthors measure group and across
from DimStores displaying as blank.
Configuring a Relationship
If you need to make an adjustment, click the cell you want to configure, and the ellipsis (. . .) button will appear.
When you click the ellipsis, a new dialog window appears displaying the logic that defines the relationship. As
you can see in Figure
11-24
, it consists of a dropdown box at the top of the window that allows you to select the
relationship type you want to use.
Figure 11-24.
The Define Relationship dialog window
In Figure
11-24
, you can see the different relationship choices. Regular is the wizard default, and it is also
the most common relationship type. In our example, this is not the correct choice, because the Order Numbers
dimension is a fact dimension. Therefore, we need to choose Fact from the dropdown list, as shown in Figure
11-25
.
