Database Reference
In-Depth Information
Figure 10-24.
The DimStores attribute relationships
5.
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 Stores Dimension
now for the stores dimension. It is a very simple dimension and should already be in the configuration we
want. still, it is a good idea to verify the settings, so let's do that now.
1.
open the Dimstores 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
there is a sibling relationship between store and storeId as shown in Figure
10-25
.
Figure 10-25.
The DimStores attribute relationships
