Drill-Across
To compare orders with shipments, do not join the two fact tables. Query each at the report’s grain on shared attributes, then merge the results.
-
-
Conformed Dimension
Orders, shipments, and returns can be compared by customer or month only if those attributes mean exactly the same thing in each. That is a conformed dimension.