Oracle Business Intelligence Applications

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

What the appropriate format for userpref_currencies_OBIA.xml

Question
1
Views
0
Comments

Hi Guys,

What is the appropriate format for the userpref_currencies_OBIA.xml

<Config>

<UserCurrencyPreferences currencyTagMappingType="dynamic">

         <UserPrefCurrencyLogicalSQL>

            SELECT "Dynamic Currency Preference"."Preference List"."Currency Preference Code", '', "Dynamic Currency Preference"."Preference List"."Currency Preference Name", 'column',"Dynamic Currency Preference"."Preference List"."Currency Support Flag" FROM "Dynamic Currency Preference"."Preference List" order by "Dynamic Currency Preference"."Preference List"."Currency Preference Name" ASC

         </UserPrefCurrencyLogicalSQL>

      </UserCurrencyPreferences>

</Config>

We will be using the Static approach.

Please advise what is the format and if i should point it out in the nqsconfig

Thanks