Forum Discussion

sgsukumaran's avatar
sgsukumaran
Resolver II
9 years ago

Row level security on Hierarchy

I am trying to implement RLS on Ownership hirerachy where an user can be a merchant, manager or director. How to acheieve this in tabular model? Any pointers on Dax would help. This is my current dax and I want to expand on this

='Product Ownership'[Merchant]=LOOKUPVALUE('Product Ownership'[Merchant], 'Product Ownership'[UPN], USERNAME())

 

 

Need Help

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    9 years ago

    hi sgsukumaran

     

    What I would suggest if you are trying to do this is to enable the RLS at the lowest level. 

     

    So what will happen is based on this, as you go up the hierarchy it will automatically filter out the data in the hierarchy.

    • sgsukumaran's avatar
      sgsukumaran
      Resolver II
      9 years ago
      It is already at the lowest level (merchant). I have to default their view based on the level in hirearchy. If i am a gmm i need to see data for all merchants under me.