How do I make the currency in a OTBI analysis match the currency displayed in an opportunity?

Here's how to display the same currency amount and symbol in an Oracle Transactional Business Intelligence (OTBI) report as appears in an opportunity.

1. Open the Oracle Transactional Business Intelligence (OTBI) Catalog. (Navigator > Reports and Analytics > Browse Catalog).
2. Click My Profile > My Account.
3. In My Account page, Preferences tab, set Currency to Entered Currency.
4. Click OK.
5. Sign out and sign in again.
6. Navigate back to the Catalog.
7. Edit the report.
8. On the Criteria Tab, click the opportunity revenue column
9. Click Column Properties > Data Format.
10. Select the Override Default Data Format option.
11. In the Treat Number As field, select Custom.
12. In the Custom Numeric Format field, enter: [$:currencyTagColumn="Sales - CRM Pipeline"."Currency"."Common Currency Code"].
13. Click Save as Default
14. Check the results in the Results Tab.

15. In the SQL Issued field query, The PREFERRED CURRENCY must be set to 'Document Currency', and not 'User Preferred Currency 1'.

    Here's what the prefix should look like:

     SET VARIABLE PREFERRED_CURRENCY='Document Currency';SELECT