Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Filter results of an OTBI report based on logged in user

Received Response
82
Views
1
Comments
Viosam
Viosam Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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)

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Apr 24, 2024 10:14AM

    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