Currency Conversion (Many To Many) RRS feed

  • Question

  • Hi...I need to implement currency converison in the cube and was wondering if you can provide your thoughts on this.

    I have a fact table which contains the same measure in multiple local rewuirement is to have a ability to view the data based on the currency selected (USD, EURO, GBP)...

    Please correct me if I am wrong but according to me this is the case of "Many to Many" relationship?

    I have a Currency Dim table (CurrencyCode and CurrencyName) and one Currency Fact Table which contains (DateKey, CurrencyKey, AvgRate)...

    I would like to know how I can achieve the many to many type of conversion ...couple I thing came in my mind which are listed below

    1. by defining the many to many relationship in dimension usage tab under the cube?

    2. Use the Business Intelligence wizard ?

    I am not sure if this can be done by both or I am missing anything here? Also please let me know what is the better way to achieve this and please share if any arcticle available which can walk through the steps...

    Any help would be greatly appreciated...



    Thanks, Gaurav
    Friday, February 4, 2011 9:49 AM

All replies