How to retrieve value of @{session.locale} on BI Server level

Akshay Ligade-Oracle

Our server run in multi language environment. We would like to show some data based on Locale (location) selected in User Preferences. @{session.locale}.

We know how to get WEBLANGUAGE in RPD (BI Server) level. But we can't get value from LOCALE (it's not a session variable).

When I log in to OBI I can chose my language:
English - United States
English - United Kingdom
If I create a report using '@{session.locale}' I get "en-us" or "en-uk" based on language selected.
From formula VALUEOF(NQ_SESSION.WEBLANGUAGE) I always get "en" which is not enough. VALUEOF(NQ_SESSION.LOCALE) does not exists.

Is there any way to get value of '@{session.locale}' in RPD (BI Server). I would like to use this value in initialization block (in RPD).

[Deleted User]

Have a look at this

https://dimensionality.ch/2016/07/12/obi-system-variables-overview/

Akshay Ligade-Oracle

Thanks for the link Christian, although I did not find any specific option to read value of '@{session.locale}' (or some other variable which contains Locale) on BI Server level (in RPD). Is this possible or not?

Regards,

Akshay

[Deleted User]

This is what exists in the RPD the so-called system session variables:

So:

1.) just create a new non-system session variable called 'something#

2.) initialize it with 'whatever'

3.) set it to "Enable any user to set the value" = TRUE

4.) in an analysis set the prefix "Set variable something='@{session.locale}';

5.) voila your session variable is now a request variable whose instantiated value has been overwritten by your front-end

You have to understand that the session locale is soemthing front-end. Getting it to the RPD isn't as direct as language.

[Deleted User]

@Akshay Ligade-Oracle Did you give up on this? For the benefit of other forum users it is courteous to finish your threads. Sharing goes both ways.

Akshay Ligade-Oracle

Hi Christian, I am just trying out this one and will update. This information you provided helps