Best paractice implementing Inprices & Gross-margin measures?

Question

Hello!
I´ve a ssas 2008 cube containing Salesdata from stores located in several countries.
The FactSales-table (200.000.000 rows) contains the "sales lines" from each receipt. The amount is stored in the local currency of the store.
Therefor I´ve a FactCurrency-table (many-to-many) to handle the exchangerates (TimeKey, SourceCurrencyKey, DestCurrencyKey, ExcangeRate)

I want to implement gross margins, in prices etc in the cube. I´m getting the inprice/costprice for each product and date from the mainframe-system and they are all is in one currency.

In what way can I implement this?
Should I store the inprice for each sales-line in the FactSales-table or should I perhaps use another table (FactInPrice) which contains Productkey, datekey & inpriceamount?

How to handle the currencies?

My ProductDim-table has around 30.000 rows.

Answer 1

Could you refer to link to see if this helps:
http://msdn.microsoft.com/en-us/library/ms175660.aspx

To implement many-to-many currency, you may need one-to-many type:
http://consultingblogs.emc.com/christianwade/archive/2006/08/24/Currency-Conversion-in-Analysis-Services-2005.aspx