OBIEE 11g multi Currency Support

3421036

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

[Deleted User]

I presume you have followed this approach, right? Configuring Currency Options

3421036 wrote: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

If that is your default then yes. Make sure to check the "Enable any user to set the value" flag.

3421036

Hi Christian,

Thanks for the reply..I have followed the procedure and deployed the rpd and  I have restarted all the services. I could able to see that all the services are up but I am not able to open rpd in online mode and Analytics page is not getting opened. We have tried stopping and starting the OPMN services but it did not work

1)When I tried to login to rpd online I am getting below error message.

Error:

[NQSError:43113] message returned from OBIS

[NQSError:13037] cannot connect to BI security service,Please make sure this is running properly (with SSL or not) in EM.

[NQSError:37001] could not connect to the oracle BI server instance..

2)For analytics below is the error:

Error 500--Internal Server Error

From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:

10.5.1 500 Internal Server Error

The server encountered an unexpected condition which prevented it from fulfilling the request.

Could you please suggest....

[Deleted User]

3421036 wrote:Could you please suggest....

Go back to the RPD which worked.

3421036

I have tried deploying old rpd,even that did not work...Even after deploying the old rpd I am not able to open rpd online and analytics application is not opening...

It is displaying same errors..

Could you please suggest

[Deleted User]

What else did you change? It's impossible that your environment "just breaks".

3421036

Before deploying the RPD which had default value as 'USD' ,I have deployed a rpd in which  the  initialization block has the value as ''select 'VALUEOF(NQ_SESSION.PREFERRED_CURRENCY)' from dual'' .Mistakenly I have given the variable name which has this initialization block as PREFERRED_CURRENCY.Consistency check did not throw any error.When I was trying to  deploy the rpd the deployment was failed showing an error as  Cluster components went down. So I  re-deployed the rpd by making changes in the initialization block as ''select 'USD' from dual;'' It  was deployed successfully,but i am not able to login rpd in online mode and analytics application is not opening.

Do you think it might be because the rpd which has value as ''select 'VALUEOF(NQ_SESSION.PREFERRED_CURRENCY)' from dual''?

please help !!!

[Deleted User]

Have you checked the log of the bi server? Just yelling "please help" wont solve your issue and the forum is not supposed to be a 24/7 free help, "do my work for me" hotline.