role playing dimensions and USERELATIONSHIP

PeterL33 If we look at your example, the challenge with individual tables will be on how to show data on the same x-axis:

for example, if I want to see an order received, shipped, and due by month, I will not have a common dimension to achieve this and will not be able to produce the expected output.  That means I need a common date table with inactive relationships to make it work. In general, it is rare you will have duplicate dimension tables.