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.