Databases Reference
In-Depth Information
Order Date Dimension
Ship Date Dimension
Order Fiscal
Year
Order
Calender Year
Ship Fiscal
Year
Ship Calender
Year
Order Fiscal
Quarter
Order
Calender Quarter
Ship Fiscal
Quarter
Ship
Calender Quarter
Order Fiscal
Month
Order
Calender Month
Ship Fiscal
Month
Ship
Calender Month
Order Day
Ship Day
Figure 7-21
Sample role-playing dimension diagrams
TIP
Develop one instance of a role-playing dimension at first. Note each role as
it is identified. After the model has been reviewed and is stable, then copy the
dimension and rename each attribute with the appropriate prefix.
The role-playing dimensions must also be represented in the fact group
diagrams. Figure 7-22 shows both the Order Date and Ship Date dimensions
as they relate to the Shipments fact group.
Order Date
Order Day
Shipping
Mode
Shipping
Mode
Ship Date
Ship Day
Call;
Shipments
Customer
Customer
Product
Item
Figure 7-22
Fact group for role-playing example
