We can use information about current user in BIP report data model using system Variables.
The user information is stored in system variables as shown below:
System Variable | Description |
xdo_user_name | User ID of the user submitting the report |
xdo_user_roles | Roles Assigned to user submitting the report. Example: XMLP_ADMIN_XMLP_SCHEDULER. |
xdo_user_report_oracle_lang | Report language from user’s account preferences. Example: ZHS |
xdo_user_report_locale | Report locale from user’s account preferences. |
xdo_user_ui_oracle_lang | User Interface language from user’s account preferences. Example: US |
xdo_user_ui_locale | User Interface locale from user’s account preferences. Example: en-US |
We can use below query in Data model for system variables:
select :xdo_user_name as USER_ID, :xdo_user_roles as USER_ROLES, :xdo_user_report_oracle_lang as REPORT_LANGUAGE, :xdo_user_report_locale as REPORT_LOCALE, :xdo_user_ui_oracle_lang as UI_LANGUAGE, :xdo_user_ui_locale as UI_LOCALE from dual |
Output:
