Determining BI languages currently in use?

599775

Hello,

currently I am planning the localization of an Oracle BI system that is already installed and working at our customer's site. For that, I need to find out which frontend languages the BI users currently have selected in their user profiles, but I have not found a way to extract this information. Is there any way to do this?

Many thanks,
Andreas

Vladimir L

Hello,


You can find locales used by users by adding to rpd special initialization block which insert session data to the table.
Steps are follow
1. create table where session data will be inserted
for example
CREATE TABLE "LOCALE_LOG"
( "USER_NAME" VARCHAR2(200 CHAR),"LOCALE_NAME" VARCHAR2(200 CHAR),"WEBLANG" VARCHAR2(200 CHAR) )
2. in RPD create session ini block with this SQL
insert into locale_log values('VALUEOF(NQ_SESSION.USER)','VALUEOF(NQ_SESSION.LOCALE)','VALUEOF(NQ_SESSION.WEBLANGUAGE)')
As connection pool you can use Usage Tracking Writer Connection Pool.
3. During creation of the ini block you will be asked about creation of variable for this ini block, you can name it as you wish since it never will be populated

Now then users log-in, their session data will be stored in LOCALE_LOG table.

Vladimir