Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
How to set the currency for an individual BI Analysis — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to set the currency for an individual BI Analysis

Received Response
61
Views
1
Comments
edited Nov 13, 2017 7:23PM in Reporting and Analytics for ERP 1 comment

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';

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!