Exchange rate tracked by market

A third way to solve this problem is to use a two-dimensional exchange rate cube MarketExchange, comprised of the dimensions Market and Date, and store exchange rates in that cube.

You can link the MarketExchange cube with the Purchase cube to calculate price per Kg and total purchase price in US dollars. This is the solution you will develop, as it provides an excellent example of inter-cube calculations with the use of DB functions.