Home Forums Data Warehousing Strategies and Ideas Does it make sense store measures in a dimension table? RE: Does it make sense store measures in a dimension table?
Bruce W Cassidy
SSChampion
Points: 12668
More actions
November 21, 2012 at 11:44 am
#1561355
I think in most ways you've answered your own question. Another name for "facts" is "measures" (this is the name that SSAS uses.)
Personally, I would pull them out and create summary fact tables ("aggregations") that present the same data.