Skip to content
BENIBIX Learn

Conformed Dimension

Data🗄️ Storage & WarehousingDimensional Modeling

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

A conformed dimension is a dimension table that many fact tables share. It has the same keys and the same meaning for all of them. A date or customer table is the usual example. Because sales and returns use the same customer table, a report can put them side by side. Teams agree on it once and then share it.
The customer table in the middle is conformed. Sales and returns both use it, so one report shows both.

Common mistake

Letting each team copy and tweak the shared table. A copy with one changed rule is no longer conformed.

Key takeaways

  1. 1
    Shared. Many fact tables use it.
  2. 2
    Same meaning. Same keys, same labels.
  3. 3
    Lines up reports. Facts can sit side by side.