What is a Conformed Dimension?
Posted by Dylan Wan on January 18, 2007
A simple answer is that a conformed dimension is a dimension that is shared across fact tables.
A conformed dimension is important because it allows queries to be executed across star schemas. This activity is also called Drill Across. When you drill across, you are adding more data from another fact table to the existing rows.
Examples of obvious conformed dimensions include Customer, Location, Organization, Time, and Product.