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 dimension that has an attribute for price you could create buckets for price instead of listing every distinct value. To set this property you select the attribute to configure and open the properties menu. T...
Read More
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 part entertainment and one part education. Who said education cannot be fun? Two chefs duel in loading a Data Warehouse in their own unique way. To impress the judges the two chefs find creative ways to present that data. Adam created an Analysis ...
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 during processing. For example, if you have a Fact table that has foreign keys pointing to your dimension that does not have the associated primary keys then those rows would land under the Unknown member. Y...
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 in the Iron Chef session this year but there are a lot of other great session you can see below. To get full information about this event and other SQL Saturdays near you go to www.sqlsaturday.com . Cafeteria Room A Ro...