what is the difference between userpref_currencies_OBIA.xml and userpref_currencies.xml

Question

Hi Gurus,

We are implementing OBIA 11.1.10, The customer want to use multi currencies. I have been doing research and i cam across the following

1- userpref_currencies.xml

2- userpref_currencies_OBIA.xml

What is the difference between them ?

Thank You

3231950 · Answer

Hi Sirini,

I understand that this is a new feature and some configurations has to be done on the userpref_currencies.xml.

but what is the use of userpref_currencies_OBIA.xml ? do we specify if we want the list of currencies to be static or dynamic there and then configure the list on

userpref_currencies.xml ?

So my question should be what is the use of userpref_currencies_OBIA.xml and when do we use it ?

Thank Yoi

SriniVEERAVALLI · Answer

Starting from 11.1.1.x release, the BI Platform added a new feature to support multiple currencies. The new session variable (PREFERRED_CURRENCY) is populated through a newly introduced currency prompt. This prompt can take its values from the xml file: userpref_currencies_OBIA.xml, which is hosted in the BI Server installation folder, under :< home>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\userpref_currencies.xml

This file contains the list of currency preferences, like"Local Currency", "Global Currency 1",…which customers can also rename to give them more meaningful business names. There are two options for showing the list of currency preferences to the user in the dashboard: Static and Dynamic. In Static mode, all users will see the full list as in the user preference currencies file. In the Dynamic mode, the list shown in the currency prompt drop down is a result of a dynamic query specified in the same file. Customers can build some security into the rpd, so the list of currency preferences will be based on the user roles…BI Applications built a subject area: "Dynamic Currency Preference" to run this query, and give every user only the list of currency preferences required by his application roles