Categories
- All Categories
- 139 Oracle Analytics News
- 25 Oracle Analytics Videos
- 14.6K Oracle Analytics Forums
- 5.6K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 52 Oracle Analytics Trainings
- 9 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
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
Answers
-
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.
0 -
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
0 -
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.
0 -
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.
0