How to show reporting currency in OTBI report

Question

Now we have 2 primary ledgers, ledger 1 with ledger currency as HKD, Ledger 2 with ledger currency as SGD.

Now we have setup 2 reporting currency in USD for the 2 ledgers respectively.

We are trying to create an OTBI with subject area using general ledger - transactional balances real time, but we cannot find the reporting currency in the report.

Is there any way we can extract the balance in the reporting currency?

Jack Cheung · Answer

https://community.oracle.com/products/oracleanalytics/discussion/comment/48733#Comment_48733

Thanks for the solution. However, I doubt it will be a little bit different from the expected result from user.

As we have already setup the reporting currency, such reporting currency is already using a specific currency rate for the balance translation. Is there any way I can extract the result from that translated table? Or which subject area I should look for?

Dimple-Nagesh-Support-Oracle · Answer

Hi,

Please find the uses of different options is BI :

Set Analytics Currency

The analytics currency settings determine the currency type that's displayed in all your analytics. It also determines how and when your currency conversion rates are calculated.

* Click Navigator Tools Reports and Analytics.
* Click Browse Catalog.
* Click My Profile and select  My Account.
* In the Preference tab, select your choice in Currency.

This shows the currency display options for users:

Currency Display Type

Description

Entered Currency

Currency used on a transaction.

<Application> Currency

Currency set up in each respective Cloud application as the common Corporate currency used company-wide.

User Preferred Currency using Simple Currency Management

Conversion to User Preferred Currency is performed at the time your run the report, and is calculated from the Corporate currency based on the last time the record was updated and saved or closed.

User Preferred Currency using Advanced Currency Management

Conversion to User Preferred Currency happens on the date your run the report, and uses the currency indicated on the record.

https://docs.oracle.com/en/cloud/saas/applications-common/23c/faacc/set-general-user-currency.html#s20058371

Hope this helps.

Thanks,

Dimple N

ravikiran goda-Oracle · Answer

Hi  User_X2EYT ,

Login to reports and analytics and go to My Account>Preferences

change currency to 'Ledger Currency' or 'Entered Currency' and test it

Regards,

Ravi