Forum Discussion
Rank changes when RLS is applied
Hi Team, I have 3 tables Accountid table (used for RLS) Dealer Master table Fact sales tables I am showing ranking of dealers based on their sales quantity. I also want to apply RLS in my...
Anonymous Yes, I was able to acheive this but the solution might affect your report performance if your dataset size is too huge. I have created 2 copies of main view, one I used for RLS filtering purpose and another for calculating rank to which RLS is not passed on and then I used TREATAS function to fetch the rank.
Please refer below update sample file.
Creating a copy of the table and not applying RLS - could this give you a problem with security?
Otherwise why to apply RLS anyways - you could simple Filter.
Anonymous I don't think it will pose any secutiry issue since we are just using the duplicated table for calculating the aggregated value.