Devin Knight
Archives: January 2011
SSAS Dimension Attribute Discretization Methods
Discretization (one of my favorite tech words to say J) is a really great feature of Analysis Services that is often forgotten. Basically what discretization does is it can take a dimension attribute and automatically place its members in buckets for you. For example, if you have a product… Read more
2 comments, 3,718 reads
Posted in Devin Knight on 27 January 2011
SQL Saturday SQLSaturday #62 - Tampa Review
For those who attended SQL Saturday #62 in Tampa I hope you enjoyed this free event. As I promised in the Iron Chef session you can download my project files here.
If you missed this session looks for it at a SQL Saturday near you. This session is one… Read more
0 comments, 1,245 reads
Posted in Devin Knight on 17 January 2011
SSAS – Hiding Unknown Member
You may have noticed when creating Analysis Services dimensions that a member is created in all of your attributes that doesn’t actually exist in your data source. The member that is created is the Unknown member shown below.
The purpose of the Unknown member is to handling errors that occur… Read more
1 comments, 14,734 reads
Posted in Devin Knight on 10 January 2011
SQLSaturday #62 - Tampa
Hey Folks just a quick reminder that next Saturday January 15th is SQL Saturday 62 in Tampa. If you haven't been to a SQL Satuday you are missing out. These have become rather large events now for both learning and networking with other SQL Server professionals. I will be speaking… Read more
0 comments, 630 reads
Posted in Devin Knight on 6 January 2011