A LearnMicrosoftBI.com reader created a Time dimension and had a Quarter attribute. After adding it to a user hierarchy, creating the attribute relationships, and making setting the KeyColumns property to both the Year and Quarter, our reader wanted to know how to use the attribute as an attribute hierarchy without the compound key taking effect. This was a great topic for a short video and you will see examples of how to set this up, and an examination of the way it was done in the Adventure Works DW sample cube.

This video runs 6.5 minutes.

This video, along with all others, can be found on the Videos page of the site.