Fact-Table

Wrong grain: when the fact table can't answer the right questions

A fact table built on monthly invoice totals looked perfect. Then the business asked for product-level, line-level, customer-level detail. And the data warehouse went silent.