Category Archives: Star Schema
Example Code to build and populate a Date Dimension
OK, I’ve found myself searching for this code a half dozen times over as many weeks. That tells me that I : a) Need to keep better track of my source code b) Need to share it on my blog … Continue reading
Posted in Modeling/Architecture, Star Schema
Leave a comment
Do as I say, not as I do
Perhaps that should be – Do as I say, not as Adventure Works and Project Real do SSAS modeling question: What’s the best approach to handling header/detail records? Approach #1) Use Measure Groups Approach #2) Consolidate via either ETL or … Continue reading