Database Reference
In-Depth Information
Configure the Dates Dimension
The Dates dimension has a number of attributes that need to be related correctly. Be sure to review it closely
and make any changes necessary.
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, access the Attribute Relationship tab.
3.
Verify that Date to FullDate is in a sibling relationship (Figure 10-27 ).
4.
Verify that Date to month is in a parent-child relationship. If not, delete the
relationship from the Attribute Relationships pane and re-create it, as shown in
Figure 10-27 .
5.
Verify that month to Quarter is in a parent-child relationship. If not, delete the
relationship from the Attribute Relationships pane and re-create it, as shown in
Figure 10-27 .
6.
Verify that Quarter to Year is in a parent-child relationship. If not, delete the
relationships from the Attribute Relationships pane and re-create it, as shown in
Figure 10-27 .
Figure 10-27. The DimDates attribute relationships
7.
set all of the relationships as Rigid by right-clicking each relationship and selecting
that relationship type from the context menu.
8.
Verify that the Attribute Relationships tab looks like Figure 10-27 .
9.
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.
 
Search WWH ::




Custom Search