Database Reference
In-Depth Information
You now have a lot of new information to think about. Let's put your knowledge to work by configuring the
dimensions created in the previous chapter.
eXerCISe 10-1: CONFIGUrING KeYS, NaMeS, aND hIerarChIeS
In this exercise you will start configuring your dimensions by verifying or changing the names, keys, and
hierarchy properties.
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 this menu item, select Run as Administrator,
and then answer Yes to close the uAC. If did not complete the project in the previous chapter, you can find
our completed version in the
C:\_BookFiles\Chapter09Files\Chapter09_Complete\PublicationsIndustries
folder.
Configure the Authors Dimension
we begin by configuring 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, select each attribute and use the Properties
window to change or verify the settings shown in Table
10-3
.
Table 10-3.
The Initial Property Settings for the DimAuthors Dimension
Attribute
Property Name
Value
Author Key
Name
Author
KeyColumn
DimAuthors.AuthorKey
NameColumn
DimAuthors.AuthorName
AttributeHierarchyVisible
False
Author Id
Name
AuthorId
KeyColumn
DimAuthors.AuthorId
NameColumn
DimAuthors.AuthorId
AttributeHierarchyVisible
True
Author State
Name
AuthorState
KeyColumn
DimAuthors.AuthorState
NameColumn
DimAuthors.AuthorState
AttributeHierarchyVisible
True
