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 Caveats & Comments: This is “warts and all” utility code. It could be optimized, but […]

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 relational operations Most clients I deal with have some form of Header/Details modeled in some […]