Restrict visibility on self data on a OTBI report

Question

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

Sivakumaran Muthusamy-Oracle · Answer

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.

Jacqueline GRANDIN · Answer

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 · Answer

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:

* Click on  Person User Name and click Filter.

Make sure the Column is converted to all upper case using UPPER() function

* Choose "is not equal to / is not in" in the operator field
* Click Add More Options and choose Session Variable
* In the Session Variable field enter USER (all caps)

5. Click on OK to apply the filter.

Hope this helps.