Monthly Archives: October 2006

With the new Microsoft BI Developer certification (MCITP: Business Intelligence Developer) on the horizon, I decided to take the "Introducing Microsoft® SQL Server™ 2005 for Business Intelligence Developers" assesment test on the Microsoft site.   After scoring 29/30 and completing it … Continue reading →

Aggregations are the lifeblood of OLAP. Properly set aggregations either make or break the user experience.   Through Analysis Manager there are two options for setting aggregations: Usage-Based Optimization and the Storage Design Wizard. Usage-Based Optimization works well when you … Continue reading →

I came across something today which stumped me for quite a bit.   For the last week I’ve been working on getting a test cube up with some real world data. I populated the cube with about 90 days of test … Continue reading →

Well, it’s time to blog. I’ve been dealing with Microsoft SQL Server Analysis Services for about three years now. The majority of that time with Analysis Services 2000 and the last several months with Analysis Services 2005. We’ve developed quite … Continue reading →