I have continued working on this and then used Excel as the Front end tool for the cube. I have come to the conclusion that I am misusing/misunderstanding how the Hierarchy works outside the cube's own browser.

While the browser lets you pull out individual levels of a hierarchy this isn't possible within Excel. With this in mind I have to reconsider where and how I use Hierarchies.

Thanks for the help