8 Replies Latest reply: Jun 29, 2016 10:04 AM by Shaun Cassingham RSS

    adding same dimension to fact table

    Shaun Cassingham

      Hi,

       

      How do I load the tables below to my data model without creating a circular reference?

      Ideally I don't want to have two sets of variables for each currency field since there are many fields in this model anyway.

       

       

      FXRateCurrency
      FXIDCurrencyID
      CurrencyFromIDCurrency Name
      CurrencyToIDCurrency Code
      Rate
      Date