Filter results of an OTBI report based on logged in user

Question

I am creating a data model for approval transactions. Is there a way to filter the results of the approvals based on the logged in user (Approver)

Nathan CCC · Answer

Here is the bit in your user guide that tells you how to get user information in your report in OTBI

For more information see

Oracle® Fusion Middleware

Data Modeling Guide for Oracle Business Intelligence Publisher

12c (12.2.1.2.0)

E77720-02

December 2016

https://docs.oracle.com/middleware/12212/bip/BIPDM/GUID-2A6E4B9B-ABCD-4CF0-A458-59B89F2443A1.htm#BIPDM223

select all 0 as s_0
, :xdo_user_name as USER_ID
, :xdo_user_report_oracle_lang as USER_LANGUAGE
, :xdo_user_report_locale as USER_LOCALE
, :xdo_user_ui_oracle_lang as UI_LANGUAGE
 ,:xdo_user_ui_locale as UI_LOCALE
from dual t