|Thoughts Around "Aggregate Fact Tables"|
|Written by Eugene Asahara|
|Sunday, 15 July 2012 16:08|
I've encountered many situations where some set of complications in a cube model were eased by using an aggregation table derived from some base fact table as the fact table. The complications leading to that choice usually include expensive on-the-fly calculations, distinct count measures, or even many to many relationships.Read more...