Categories
- Analysis Services (11)
- Business Intelligence (23)
- Community (6)
- DAX (1)
- friends (1)
- Hardware (1)
- Integration Services (1)
- MDX (7)
- Microsoft (6)
- Modeling/Architecture (8)
- OLAP (6)
- Operating Systems (4)
- Reporting Services (1)
- research (1)
- Software (2)
- SQL Server (12)
- Star Schema (2)
- Uncategorized (10)
- Virtualization (3)
- Web (4)
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