How to restrict OTBI dashboard report output when User field isn't in subject area?
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!