EPM 2007 handles multi-currencies at the Project level using the following four options (Tools -> Options -> View -> Currency options):
¾ Decimal digits
While this works fine at the project level, there is no out of the box mechanism to manage exchange rates between each of the project currencies. For instance if you enter costs in Dollars ($) in Project A, and in Euros (€) in Project B, the data will be added on the server if you have a view that sums the two.
Therefore if you do work with different currencies it is key to put in place a currency conversion mechanism (in the Reporting database using Events, and potentially Analysis Services 2005 currency conversion functionalities for instance).
Currency information at the project level is stored in the following tables:
MSP_PROJECTS table in Published database:
MSP_EpmProject table in Reporting database:
The currency field is based on ISO 4217 (USD, JPY, EUR, and so forth); for a complete list refer to: http://www.id3.org/ISO_4217