Regionalization Part Two
Hello Nathan - our monetary data is not stored converted into a single currency. For customer x the currency of the numbers might be USD, while another customer it may be CAD, yet a third might be GBP. Our reporting uses a significant number of reports publicly on the dashboard, so it isn't realistic to have a different report per currency.
As we discussed on the phone today, we are doing some creative work using the DASH-XML product and some custom work returning the currency for the data in order to use the same YF report and dash-XML dashboard to show one currency symbol for customer A and another currency. The problem I haven't figured a way around yet, is when the currency symbol is defined (Hard coded) as a prefix for the amount, and now we want that prefix to be dynamically set based on an attribute of the the data set. The currency symbol shows up on mouseovers/popups on line charts, pie charts, etc. Our ideal would be to figure out how to dynamically indicate/change the currency based on the customer that is viewing the data. Possibly even the mouseover could have another attribute that says "Currency: USD ($)" See the attached screen shot for a good look at what I would like to figure out how to accomplish.