currency settings in ad-hoc analysis

Currrently you can change how currency is displayed in site catalyst, but you cannot do this in ad-hoc. This makes reporting a real pain if you want to look at reports from both tools. It would also be ideal if revenue displayed in the systems based on the actual days exchange rate and not the current days exchange rate, or if we at least had the ability to look at it both ways.