How to set the currency for an individual BI Analysis

Summary

Instructions for ensuring that data is always displayed in the correct currency on your reports and dashboards.

Content

Unless otherwise specified in the analysis, OTBI based reports and dashboards will display data in the User's Preferred Currency.  By setting the currency at the analysis level, you can ensure that data is always returned in the currency that makes sense for that report and/or dashboard.

Follow these steps to set the currency for an analysis.

1) Edit the Analysis

2) Navigate to the Advanced tab

3) Enter one of the following in the Prefix region

       SET VARIABLE PREFERRED_CURRENCY='Local Currency';

       SET VARIABLE PREFERRED_CURRENCY='Project Currency';