Database Reference
In-Depth Information
3.
set the store to storeId relationship as Rigid by right-clicking the relationship and
selecting that relationship type from the context menu.
4.
use the Build menu to verify that the dimension builds successfully (Figure
10-23
). If
it does not, troubleshoot the problem or delete the dimension from solution Explorer
and go through the steps again, being careful to include any steps you may have
omitted.
Configure the Orders Dimension
now we turn to the orders dimension. It is even simpler than the Dimstore dimension and should not require
any configuration, because there is only one attribute in this dimension. Therefore, there cannot be any
attribute relationships. Your goal is to review the current design.
1.
open the Dimorders 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 and verify
that it looks as shown in Figure
10-26
.
Figure 10-26.
DimOrders Attribute Relationships box is empty
