Currency Conversion with complex datamodel

[Tahreem24]

Hi,

I have one tricky requirement from stakeholder. We have developed 6 different reports based on complex datamodel but all amount are showing in Euros for European based clients. The same reports have been shared with UK based clients and they want to see all amount in pounds. And we have lots of different categories of amount column (15-20 columns). So, its not a single amount column that I would simply multiply it with UK currencies. 

So what could be the feasible solution for this currency conversion on entire report?

Any lead would be highly appreaciated!

[Tahreem24]

@lbendlin , Thanks for your reply.
I am gonna use UK Pounds rates and like I mentioned same shared dataset has been using in 6-7 reports and every reports has a diferent granular levels.

I hope I explained it well.

[lbendlin]

"UK Pound rates"  is not a usable term.  Based on what institution?  Daily or monthly? Accounting rates?  Other rates?

[Tahreem24 · Accepted solution]

@lbendlin , Basically exisiting reports are in Euro currency and some clients want to see only UK Pounds and we have complex data model like 4 fact tables and 10 Dim tables. And Some pages have Day wise granular level to track.

But I found, in our dataset we have local currencies details so it will solve my issue. 

Thanks for your time 🙂

[lbendlin]

Which exchange rates are you planning to use?  What granularity? Daily, monthly?