adding same dimension to fact table

[#1]

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.

FXRate	Currency
FXID	CurrencyID
CurrencyFromID	Currency Name
CurrencyToID	Currency Code
Rate
Date

[migueldelval]

Hi Shaun,

FXRATE:

Load

FXID,

CurrencyFromID,

CurrencyToID,

Rate,

Date;

From SQL [...];

left join

CURRENCY:

Load

CurrencyID,

CurrencyName,

CurrencyCode;

From SQL [...];

Try it, but it´s better to attach all your data model to see it.

Regards

Miguel del Valle

[#3]

Sorry Miguel. I wasn't clear.
I need the CURRENCY.CurrencyID to join on FXRATE.CurrencyFromID
I also need the CURRENCY.CurrencyID to join on FXRATE.CurrencyToID

[migueldelval]

Sorry Shauncass, but I can´t understan you.

If you want to join tables you need same field equal in both tables to make a relationship.

Attach an example of data, please.

Regards

Miguel del Valle

[#5]

My data looks as follows;

CURRENCY

CurrencyID     CurrencyName     CurrencyCode

1                    US Dollar             USD

2                    Euro                     EUR

3                    British Pound        GBP

FXRATE

FXID              CurrencyFromID     CurrencyToID     Rate

1                    1                           2                        0.90

2                    1                           3                        0.74

3                    2                           3                        0.83

In my dashboard I want to represent something similar to the following;

FXID              CurrencyFrom     CurrencyTo     Rate

1                    USD                   EUR               0.90

2                    USD                   GBP               0.74

3                    EUR                   GBP               0.83

[migueldelval · Accepted solution]

Hi Shauncass,

Try this example please and tell me.

Regards

Miguel del Valle

[#7]

Miguel,

This looks perfect, how did you go about achieving it? What is in your load script?

[migueldelval]

Hi shauncass,

I made a fact table with the equivalent values.

Regards

Miguel del Valle

[#9]

Thank you