Yesterday I was thrilled to find out that my session "Common Analysis Services Design Mistakes and How to Avoid Them" was accepted for SQL PASS this October. This will be my first solo PASS session I have ever presented so I'm really excited! The last time I attended PASS was in 2008 when I co-presented with some guy I meet while in Seattle named Brian Knight . PASS was truely one of the best experiences I had my my career at that point and that is why I'm so excited to be returning this year. T...
Read More
For many Analysis Services developers building dimensions with many attributes and hierarchies is something that comes as second nature to them. However, I’ve found for those that are new to Analysis Services changing the KeyColumns property can be particularly difficult to understand why and when it is necessary. In a previous post I discussed the need for defining attribute relationships in a dimension. The side effect of have attribute relationships is that you will often, depending on your d...