Average Quarterly MB Exchange rate
I have to create a report on sales cube which apart from data in local currency should also calculated Average Quarterly MB exchange rate and then use this Average Quarterly MB exchange rate to convert in USD.
Average Quartely Exchange rate is not stored in any table instead MB exchange rates are stored in TCURR table.
THis report will basically show the impact of Exchange rate on billing.
Let me know which is the best way to develop such report which is less hard runtime of report.
Thanks and Regards,