Oracle Transactional Business Intelligence

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

How to restrict OTBI dashboard report output when User field isn't in subject area?

Received Response
18
Views
5
Comments
Rank 3 - Community Apprentice

Hello,

I'm setting up an OTBI dashboard which will only return rows in report(s) based on user details, i.e. User is equal to/is in @{NQ_SESSION.USER}. However, the subject area for one of these reports only contains email, not User detail. I've tried converting the email to UPPER(email) and using this as User and although the output matches the function>system>User, it's not restricting. Does anyone have any suggestions on how I achieve this?

Thank you!

Tagged:

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 8 - Analytics Strategist
    edited Feb 11, 2025 1:45PM

    How to restrict OTBI dashboard report output when User field isn't in subject area?

    Hi @Fiona Marran,

    Can you please send some more details like:

    • Which SA are you trying here?
    • If possible attach your report XML / Catalog.

    It'll help to replicate the issue at our end also will help to find any resolution.

    Thank You!

  • Rank 3 - Community Apprentice

    Should note that I'm using Projects - Performance reporting real time and Project Control - Budgets real time SAs

  • Rank 3 - Community Apprentice
    edited Feb 11, 2025 1:50PM

    Thank you for the response @Bhaskar Konar, it's appreciated.

    I'm using Projects - Performance reporting real time and Project Control - Budgets real time SAs.

    Please note I've included additional email and User columns.

  • Rank 6 - Analytics Lead

    @fiona marran,

    can u pls share us with what is the current output vs expected output in the report

  • Rank 3 - Community Apprentice

    Hi @ravikiran goda-Oracle thanks so much for the response. I actually resolved this by returning UPPER (email) and matching against USER and waited for a scheduled process to run and it's now restricting as expected. Really appreciate you coming back on this.

Welcome!

It looks like you're new here. Sign in or register to get started.