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.
-
-
Measure Additivity
Learn which measures can be summed across every dimension, which only across some, and why a ratio stored per row generally breaks when it is rolled up.