Conformed Facts

Conformed facts are measurements with a consistent, agreed-upon definition across the enterprise. When the same metric appears in multiple fact tables or data marts, it should use the same business rules, calculation logic, units and naming conventions.

For example, sales_amount should have the same definition - such as net sales after discounts and excluding tax - whether it appears in a retail sales fact table or an online sales fact table. This ensures users get consistent and comparable results, regardless of which fact table they query.

NOTE

A conformed fact is not simply a measure with the same name. Two revenue measures are not conformed if they use different business rules.