Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OBIEE 11g multi Currency Support

3421036Apr 13 2017 — edited Apr 14 2017

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!!

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details