• So I was able to get my problem resolved.

    I explained there were two hops from the dimension to the FACT table. The reason I was getting duplicate rows was because the first table had no relationship with the FACT.

    Thanks to the link below, I was able to set the first table as a Measure group and connect my DimEntOrg dimension to it with a Many to Many relationship in the dimension usage.

    The keys are now connected and all the necessary values are populating correctly.

    This learning curve took me through the use of M:N as a dimension usage relationship - one I had never used before.

    http://social.technet.microsoft.com/wiki/contents/articles/19854.tutorial-many-to-many-dimension-example-for-sql-server-analysis-services.aspx