General OBIEE

Get Involved. Join the Conversation.

Topic

    Benjamin Francois
    How to use session variables to customize a report outputAnswered
    Topic posted July 24, 2014 by Benjamin FrancoisBronze Medal: 1,250+ Points 
    370 Views, 4 Comments
    Title:
    How to use session variables to customize a report output
    Content:

    Hi,

    I was wondering if someone has already use session variable to customize the output of a report.

    I'm currently creating a data model and I would have wanted the translatable field to be automatiocally set in the language of the user that is running the report.

    I found the sesion variable :xdo_user_ui_oracle_lang (User interface language from the user's account preferences. For example: US) but I have not been able to use it in a report.

    thanks for your help,

    Benjamin

    Best Comment

    Kumaran Raviprakash

    So are you using this variable in your data model and getting the value in the data xml, then based on the same you should be able to base your report output on the xml value.

    Comment

     

    • Kumaran Raviprakash

      So are you using this variable in your data model and getting the value in the data xml, then based on the same you should be able to base your report output on the xml value.

    • Benjamin Francois

      Hi Kumaran,

       

      That's what I'm trying to do. I tried to wrote query that returns this value but nothing works so far ... any ideas ?

       

      regards,

      Benjamin

    • Ashish Harbhajanka

      Hi,

      Did you tried creating a seperate data set and use some query like Select :<xdo_var> as lang_session from dual ;

       

      I tried for username and it works perfectly fine.

    • Gael Chevallier

      Hi Benjamin,

      If the translation you need is linked to stored data, did you try to use the language table(table name_TL) instead of the base table in your DM ?

      Gael.