Double Counting in Aggregation
Join an order to its shipments and the order amount appears once per shipment. The join is correct; the sum is not. This is where inflated totals come from.
-
-
Fact Table Grain and Aggregation
Wrong totals rarely raise an error. See why grain is a contract, which facts you may not sum, and the join that inflates a number without warning.
-
Double Counting
Recognize double counting when one benefit or cost appears under several criteria, check what each criterion includes, and keep weights honest.