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

Posted in Analysis Services, Business Intelligence, MDX, Modeling/Architecture, OLAP, Star Schema | Leave a comment