Database Reference
In-Depth Information
Figure 10-23.
Building the project
After you build the project, you will want to browse the dimensions to verify that the design is correct, but
we still have a few steps to accomplish before we can do that. For now let's concentrate on getting the attribute
relationships configured in the next exercise.
eXerCISe 10-2: CONFIGUrING attrIBUte reLatIONShIpS
In this exercise, you will configure the attribute relationships for each of the dimensions for the ssAs project.
Let's start with the simplest ones and move onto the more complex as we go.
Note:
If the solution from the previous exercise is closed, open Visual studio by clicking the start button and
navigating to All Programs ➤ Visual studio 2010. Right-click the menu item, select Run as Administrator, and
then answer Yes to close the uAC.
Configure the DimAuthors Dimension
since we just talked about it, let's start with the Authors dimension.
1.
open the DimAuthors 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 Relationships tab (Figure
10-19
).
3.
Verify that Author to AuthorId is in a sibling relationship and that Author to
Authorstate is in a parent-child relationship, as indicated in Figure
10-19
. If not,
delete the relationships from the Attribute Relationships pane and re-create them, as
shown in Figure
10-20
.
4.
set the Author to AuthorId relationship as Rigid and the Author to Authorstate
relationship as Flexible by right-clicking each relationship and selecting the
relationship types from the context menu (Figure
10-24
).
