SSAS with Type 2 Slowly Changing Dimensions and Duplicate Members in Attribute Hierarchies

Slowly changing dimensions are an integral part of any BI project and while most people are familiar with handling this in the data warehouse, exposing these dimensions to end users through an Analysis Services cube can sometimes be confusing for the end users if not done properly.

Having had such a case recently I have decided to do a quick post explaining some pitfalls as well as ways to deal with Type 2 SCDs in SSAS. There was a lot of questions and answers on the MSDN forums as well as other blog posts but few addressed the issue of having duplicate member names in an attribute hierarchy in an easy and straight forward way.