How to restrict OTBI report prompt values based on the role of the user logging in

Question

I am creating an OTBI report. Need to implement the security restriction.

The prompt values should be displayed based on the role of the user who is logged in. Please help.

Currently, the query used for prompt is:

SELECT "Position"."PER_POSITIONS_DFF_B_N_2DN_RG_STRCTR_" FROM "Workforce Management - Worker Assignment Real Time" FETCH FIRST 65001 ROWS ONLY

Sandeep S. Chauhan-Oracle · Answer

Hi,

You can use System Variables (Analytics Publisher) like xdo_user_name in your query.

https://docs.oracle.com/en/cloud/saas/otbi/otbi-pub-design/include-user-information-stored-system-variables-your-report-data.html#GUID-D9F15F1D-1721-46BB-8938-948221912921