🗄️Conformed Dimension
Also known as Shared Dimension, Conformed Dimensions
One shared table, used by many fact tables, so their sums match.
Think of it like
It is like one big calendar on the fridge. Mum, Dad and the kids all use it.
Example
Sales, returns and web visits all join to one shared date table. A report can then show all three by week with no extra work.
Why it matters
Without it, each team makes its own customer table. Their totals never quite match.
Definition
Common mistake
Key takeaways
- 1Shared. Many fact tables use it.
- 2Same meaning. Same keys, same labels.
- 3Lines up reports. Facts can sit side by side.