• Thanks for your comments.

    I am using reporting rather than analysis services, just pre-disposed to treating everything as a warehouse.

    I take your point regarding re-use of a dimension but how would this be handled in the scenario where, for the sake of argument, two country code fields exist on a fact table (ie origin and destination country). If these country codes were different would this create two paths via the country dimension to the fact, or would this not be an issue.