Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to use session variables to customize a report output

Received Response
41
Views
4
Comments

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 1 - Community Starter

    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.

  • Rank 1 - Community Starter

    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

  • Rank 5 - Community Champion

    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.

  • Rank 1 - Community Starter

    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.

Welcome!

It looks like you're new here. Sign in or register to get started.