Interestingly enough, the behavior is due to the attribute relationships and not the hierarchy. Have a look at the following post...following a similar approach would give you the required behavior: http://www.sqlservercentral.com/Forums/Topic1802971-17-1.aspx