2 Replies Latest reply: Mar 14, 2017 3:23 AM by Adam Davies RSS

    performance issue in currency conversion

    Gautham Prasad

      hi,

       

      i want to know which is the best approach for currency conversion in our dashboard. All datas are in local currency, Need to show the data in local currency as well as in USD using a filter. I;m multiplying the currency values with the data on the fly.

       

      is it right approach for the currency conversion or multi currency in the dashboard? we have more than 3 million records in the fact table.

       

      find the attached application which is sample of our model (not exact replica).

       

      Please give an better alternate interms of performance. thanks in advance.