Database Reference
In-Depth Information
Configure the Titles Dimension
next we configure the Titles dimension. As in the previous exercise, this is the one that is most complex.
Carefully review each relationship. Remember that the relationships will automatically be correctly mapped if
you remove and reconfigure them. so, all you need to do is replace them if they are currently incorrect.
1.
open the DimTitles dimension editor by right-clicking the dimension in solution
Explorer and selecting View Designer from the context menu.
2.
when the dimension editor opens, access the Attribute Relationship tab.
3.
Verify that Title to TitleId is in a sibling relationship (Figure
10-28
).
4.
Verify that Title to TitlePrice is in a sibling relationship (Figure
10-28
).
now let's work on the published dates attributes.
5.
Verify that Title to PublishedDate is in a parent-child relationship. If not, delete the
relationship from the Attribute Relationships pane and re-create it, as shown in
Figure
10-28
.
6.
Verify that PublishedDate to PublishedFullDate is in a sibling relationship. If not,
delete the relationship from the Attribute Relationships pane and re-create it, as
shown in Figure
10-28
. This will automatically remap the relationship correctly.
7.
Verify that PublishedDate to Publishedmonth is in a parent-child relationship. If not,
delete the relationship from the Attribute Relationships pane and re-create it, as
shown in Figure
10-28
.
