Forum Discussion
Ammulu_M
1 year agoHelper I
Team rank after applying RLS
I have team rank measure before applying the rls it was working fine after applying the rls, i'm getting rank 1. I have a main file which has employee details like name,id,email,supervisor by date...
raji_n
1 year agoResolver II
Ammulu_M I think you have to use another fact table for your ranking, that way RLS wont affect the ranks.
- Ammulu_M1 year agoHelper I
Could you explain in detail how to do it
- raji_n1 year agoResolver II
you can apply RLS roles on one table and for the other table, do not apply RLS but simply show the KPI at levels, that way rank will not be affected even when RLS is applied for other parts of the report.
- Ammulu_M1 year agoHelper I
I have to create connection between those tables right. If i give connection rls will apply to that table also