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 .
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:
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.