Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

benchmark data in combination with Row Level Sequrity

Hi.

 

We want a report that uses Row Level Sequrity so people see there own data.
But they also want benchmark data what the other roles do. This benchmark is a total and average.

When we use RLS all the data is filterd for this role and a benchmark is not possible.

 

Example.

Manager X see only his department, but can also see the total and average of all managers

 

Wiht kind regards, Norbertus

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous ,

     

    I think you can create another table to calculate the total and average.

     

    And you need to make sure that the new table is not linked to your old data model.

     

    So the RLS won't effect the new table you created.

     

    Then for every one, they will see the total and average.

     

    Please try.

    Thanks.

    Aiolos Zhao