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
16
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

Welcome!

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