Report Portal

Thoughts Around "Aggregate Fact Tables"

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...

Tags: design

 

2007-2015 VidasSoft Systems Inc.