Hi VA Developer,
I have data from multiple countries (~10) from in a singe table . Now I have challenge with Local to USD currency conversion. I need to have data in both currency as report viewer can be local or global (USD) . I need to have a drop down with Local and USD currency.
Can anyone please help me with optimized solution .
Thanks
Ruchir
Have you already sourced the currency exchange rates and they are in your data?
No, I have not. I am planning to create to table with exchange rates and later have a join with master Data.
Your exchange rates will need to be in the same table as the currency data for you to do the currency conversion calculations and to display your analysis in a single report object. It would help if you explained what type of report(s) you want.
You could have a separate dropdown list for the chosen currency, then have an interraction that filters your other report object by the currency. This would require you to have each currency on a separate row in your source data.
I think row-level security might be useful here. With RLS, a user who works in a particular country would only be able to see his/her own country's currency data, while head office would be enabled to see all currencies. I'm not an expert on this topic so I'm hoping someone with experience in RLS can help out.
This link should point you in the right direction:
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.