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

Fiona Marran

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!

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/24557/how-to-restrict-otbi-dashboard-report-output-when-user-field-isnt-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!

Fiona Marran

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

Fiona Marran

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.

Project Query.txt

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

ravikiran goda-Oracle

@fiona marran,

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

Fiona Marran

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.