Forum Discussion

Tahreem24's avatar
Tahreem24
Super User
2 years ago
Solved

Currency Conversion with complex datamodel

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!

Need Help
  • Tahreem24's avatar
    Tahreem24
    2 years ago

    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 🙂

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

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

  • Tahreem24's avatar
    Tahreem24
    Super User
    2 years ago

    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's avatar
      lbendlin
      Super User
      2 years ago

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

      • Tahreem24's avatar
        Tahreem24
        Super User
        2 years ago

        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 🙂