Forum Discussion

samdthompson's avatar
samdthompson
Memorable Member
6 years ago
Solved

RLS with comparitives

Hello, I have a report with circa 300 low level users, 10 mid level (regional type roles) and 20 top level users (corporate type roles). I have RLS instituted and it works fine. No one can see anythi...
Data Protection
General Comment
Need Help
  • samdthompson's avatar
    samdthompson
    6 years ago

    no sensible, efficient solution with the current programme. a pity since it seems a typical sort of thing users would want to achieve.

  • samdthompson's avatar
    samdthompson
    Memorable Member
    6 years ago

    Thanks for the suggestions but these are variants on the dynamic security I already have. They limit the lowest level to seeing only the lowest level. I want each level of user to see the detail for there area of responsibility AND summarized data from the next level up. 

    For instance the lowest level would see the prices they have sold a bunch of products for and who they sold them to in great detail but would also see the average regional sales price for comparison benchmarking reasons. That average is made up of their peers sales prices withtin their region. 

     

    I dont really want to create a regional level table since its just a repitition of the same data and seems a very inefficient solution.