Feeders - for conversion rule
Posted: Thu Aug 03, 2017 7:50 pm
Hi ,
Cube has data loaded in local currency for Mexico and USA .
For budget alone, we wanted Mexico 's value to be converted to USD .so that we can see budget in usd as a whole .
SO I am writing the below rule :
['MX',Currency:'USD', 'Sales Measures': 'Budget','FX Rate':'Actual'] = N: ['MX',Currency:'Local Currency', 'Sales Measures': 'Budget'] *
(((DB('Exchange Rates', 'Actual', !Currencies, !Currency, 'Ending Rate', !Months))+(DB('Exchange Rates', 'Actual', !Currencies, !Currency, 'Ending Rate', ATTRS('Months', !Months, 'Prior'))))/2);
This for Mexico country and usd currency and budget measure does the following calculation
takes the value of budget in local currency and multiplies it by average of the month selected and prior month dollar converted rate .
Everything looks good and works fine .
I am not sure of the feeders here :
is it just the current one we have
[Currency:'Input Currency'] => [Currency:'USD'];
or should i be more specific here , the above one works but I know there is definetely a better way than this.
Cube has data loaded in local currency for Mexico and USA .
For budget alone, we wanted Mexico 's value to be converted to USD .so that we can see budget in usd as a whole .
SO I am writing the below rule :
['MX',Currency:'USD', 'Sales Measures': 'Budget','FX Rate':'Actual'] = N: ['MX',Currency:'Local Currency', 'Sales Measures': 'Budget'] *
(((DB('Exchange Rates', 'Actual', !Currencies, !Currency, 'Ending Rate', !Months))+(DB('Exchange Rates', 'Actual', !Currencies, !Currency, 'Ending Rate', ATTRS('Months', !Months, 'Prior'))))/2);
This for Mexico country and usd currency and budget measure does the following calculation
takes the value of budget in local currency and multiplies it by average of the month selected and prior month dollar converted rate .
Everything looks good and works fine .
I am not sure of the feeders here :
is it just the current one we have
[Currency:'Input Currency'] => [Currency:'USD'];
or should i be more specific here , the above one works but I know there is definetely a better way than this.