Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

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

Restrict visibility on self data on a OTBI report

Received Response
52
Views
3
Comments
Jacqueline GRANDIN
Jacqueline GRANDIN Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Hello,

How can I restrict the visibility on self data for a user? in an OTBI report.

For exemple : A HR representative opens a report. He will see all the population, except himself. It is sometimes automatic, with the security in the system but not on all reports.

Thanks,

Jacqueline

Tagged:

Answers

  • Sivakumaran Muthusamy-Oracle
    Sivakumaran Muthusamy-Oracle Rank 3 - Community Apprentice

    Hi @Jacqueline GRANDIN ,

    To enforce restriction on self data you can apply a filter condition on UPPER("Worker"."User Name") <> VALUEOF(NQ_SESSION."USER")

    You can follow this steps:

    1. Click on Person User Name and click Filter.
      Make sure the Column is converted to all upper case using UPPER() function
      image.png
    2. Choose "is not equal to / is not in" in the operator field
    3. Click Add More Options and choose Session Variable
    4. In the Session Variable field enter USER (all caps)
      image.png

    5. Click on OK to apply the filter.


    Hope this helps.

  • Jacqueline GRANDIN
    Jacqueline GRANDIN Rank 2 - Community Beginner

    Hello and thank you for your answer!

    It is working on most report but not on the one that I want to modify.

    I would like to do it on a specific one : an extract of the 9BOX tasks (Talent review). And I would like to restrict the visibility for the employee who is concerned about this task (the one for whom the task needs to be done). Any idea on the data that I could use ? If I use Person user name, I will restrict the visibility for the person in charge of doing the task.

    Thanks,

    Jacqueline

  • Sivakumaran Muthusamy-Oracle
    Sivakumaran Muthusamy-Oracle Rank 3 - Community Apprentice

    Hi @Jacqueline GRANDIN ,

    Happy to hear you are able to resolve for most of the reports.

    Request you to share the catalog or the XML of the report you wanted to apply this logic.

    Also please highlight the column for which you specifically wanted this restriction.