1 Reply Latest reply: Dec 1, 2009 11:09 AM by Vladimir L RSS

    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
        • 1. Re: Determining BI languages currently in use?
          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