• As the reply is quite long I have attached a word doc. This shows the creation of a dimension same as yours, the fact table presented slightly differently. There are sceen shots.

    The way to do it revolves arounf the dimensions tab on cube editor and the way you have joined the tables in the data source view.

    All the views have been hardcoded. You do not need to do this. I have just done this to give you a taster so that you can see what can be done.

    Hope this helps.

    😎