Exchange rate calculation within a cube

One way to address exchange rates would be to add an Exchange Rate element to the Purmeas dimension. Then, as analysts add information on sales, they would enter the exchange rate for the sale at the same time. You could then write a rule to calculate the price per Kg in US dollars.

One problem with this approach is that it requires a lot of excess data entry, with the exchange rate being duplicated for each fish type. The exchange rate does not actually vary by fish type, but rather by the day and the currency in use at a particular market. The duplicate data also invites errors. It is easy to make a mistake with one or another of the many identical entries.

Though storing exchange rates in the cube where you want to calculate the price in US dollars is a valid approach, it is not the most efficient solution.