This site is currently read-only as we are migrating to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,967 Users
  • 2,269,775 Discussions
  • 7,916,823 Comments

Discussions

Determining BI languages currently in use?

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
Tagged:

Answers

  • Vladimir L
    Vladimir L Member Posts: 38
    edited Dec 1, 2009 12:09PM
    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
    Vladimir L
This discussion has been closed.