This measure, successfully converts my measure to the currency selected. So if I get data, from the 1st of the month, till the 15th of the month, what will happen is that the exchange rate taken for the currency selected would be of the 15th of the month.
CREATE MEMBER CURRENTCUBE.[Measures].[Comp Money In] AS null;
SCOPE([Dim Time].[Date Key].members);
[Measures].[Comp Money In]= [Measures].[_Comp Money In]/[Measures].[Last Currency Rate];
end scope;
However what I want is that the aggregated amount, is taking into consideration the DAILY closing of the exchange rates. So the 1st of the month aggregated with the 1st of the month exchange rate, 2nd the same, 3rd... So on so fourth.
I am sure that in my fact having the currency exchange rates, there is 1 exchange rate per day which would be the closing one.
How can I do this? I am on MS SQL 2008 R2 standard, so I cannot use measure expressions, or semi additive measures.