Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

OBIEE 11g multi Currency Support

Received Response
1
Views
7
Comments
3421036
3421036 Rank 2 - Community Beginner
edited Aug 13, 2024 6:03PM in Oracle Analytics Cloud and Server

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

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    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
    3421036 Rank 2 - Community Beginner

    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]
    [Deleted User] Rank 2 - Community Beginner 
    3421036 wrote:Could you please suggest....

    Go back to the RPD which worked.

  • 3421036
    3421036 Rank 2 - Community Beginner

    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]
    [Deleted User] Rank 2 - Community Beginner

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

  • 3421036
    3421036 Rank 2 - Community Beginner

    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]
    [Deleted User] Rank 2 - Community Beginner

    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.