In data warehousing, a conformed dimension is a dimension that has the same meaning to every fact with which it relates. Conformed dimensions allow facts and measures to be categorized and described in the same way across multiple facts and/or data marts, ensuring consistent reporting across the enterprise.
Examples of conformed dimensions include: Time, Customer, Product, Region. "Time is a common conformed dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning when joined to any fact table, cf., etload.com.
Related Terms: Data mart, star schema
|DSS Home | About Us | Contact Us | Site Index | Subscribe | What's New|
|Copyright © 1995-2019 by D. J. Power (see his home page).
DSSResources.COMsm is maintained by Daniel J. Power of
PowerEnterprises.net. Please contact him at djpower1950 at gmail.com with questions. See disclaimer
and privacy statement.