The Currency Code column is derived from the currency dimension and the amount column is derived from the respective Fact. During runtime, based on the user preference currency type which is passed to BI Server session variable, PREFERRED_CURRENCY is used to evaluate the currency column and the amount column based on the below expressions.
In BI Answers, these columns are exposed as shown below. A Currency Type change is transparent to the end user. When querying in Oracle Business Intelligence Answers, pull the currency code with the Purchase Order Distribution Amount.
This feature does not support formatting the amount that enables Oracle BI EE to automatically display the correct currency symbol based on the user's preferred currency. Instead, use the currency code column for each currency type which is pulled into every report along with the currency amount column.
For more information, see the section about configuring currency options in the Oracle Fusion Middleware System Administrator's Guide for Oracle Business Intelligence Enterprise Edition.