Hi,
We have requirement for multi currency values. When ever the user logins in to analytics and selects the currency option in weblogic->My Account then the report has to be displayed according to the selected value in the MY Account option .We have followed the below steps
1)modified the userpref_currencies.xml
2)create a session variable preferred_currency in rpd.
My issue is what is the sql that has to be written in intialization block for variable preferred_currency.
if i put select 'USD' from dual in the intialization block is it correct ? and default value for variable is USD
Thanks in advance!!