|
The fact table could contain a currency dimension, which could be linked
to the dimension table which carries the detail on which different types
of currencies.
To add complexity to this situation, sometimes there are multiple exchange
rates across two currencies. For example, one can be the exchange rate published
by the federal bank and other is the "internal" exchange rate across two
business units or locations within the organization. With each different
exchange rate, one has to have an additional set of measure fields within
fact table.
|
