Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

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

Need to restrict OTBI report prompt values based on the user logging in

Received Response
41
Views
2
Comments
Sharmava
Sharmava Rank 3 - Community Apprentice
in Oracle Transactional Business Intelligence Forum

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

The prompt values should be displayed based on 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

Answers

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics & AI Strategist

    Hi @Sharmava,

    Please use the following SQL which will make sure the security in place.

    SELECT "Position"."PER_POSITIONS_DFF_B_N_2DN_RG_STRCTR_" FROM "Workforce Management - Worker Assignment Real Time" WHERE "Worker"."User Name" =  VALUEOF(NQ_SESSION."USER")

    Hope this help.

    Cheers,

  • Sharmava
    Sharmava Rank 3 - Community Apprentice

    Thankyou Bhaskar.

    Please let me know what should be used if prompt values should be displayed based on the role of the user who is logged in.