How to use session variables to customize a report output

Question

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

Gael Chevallier-4294 · Answer

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.

AshishERPCloud · Answer

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.

BenjaminFusioh · Answer

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