04-conformed-dimensions

Conformed dimensions are standardized dimension definitions sharing identical naming, keys, attributes, grain, and a single source. They prevent data silos by ensuring dimensions are consistently usable across multiple fact tables for cross-process analytics.

Design a bus matrix by mapping business processes to dimensions, identifying which dimensions require conformed definitions. This planning document establishes the enterprise data warehouse framework for cross-process analytics and drill-across query execution.

Drill-across queries combine measures from multiple fact tables by joining them through shared conformed dimensions. This requires dimensions with identical keys and attributes across tables, enabling unified reporting across disparate business processes.

Shrunken dimensions are needed when designing subset dimensions for aggregate fact tables. They maintain conformed dimension integrity while providing the reduced granularity required by aggregated measures, ensuring consistent reporting across hierarchical levels.

Yes, conformed dimensions enable integrating sales and inventory data models by defining a single shared dimension, such as dim_product. Both fact_sales and fact_inventory tables reference this identical dimension, allowing unified reporting on sales and stock levels.

Conformed dimensions require strict enforcement of identical naming, keys, attributes, grain, and single source definitions. This rigidity limits flexibility when disparate source systems have conflicting dimensional structures or varying granularity requirements across business processes.