Database Reference
In-Depth Information
Table 10-5. The Initial Property Settings for the DimOrders Dimension
Attribute
Property Name
Value
Order Number
Name
OrderNumber
KeyColumn
FactSales.OrderNumber
NameColumn
FactSales.OrderNumber
AttributeHierarchyVisible
True
3.
when you are finished, your dimension editor should look similar to Figure 10-16 .
Figure 10-16. The DimOrders dimension after configuration
Configure the Dates Dimension
now, it's time to configure the Dates dimension.
1.
open the DimDates 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 in Table 10-6 .
 
 
Search WWH ::




Custom Search