Forum Discussion

Ammulu_M's avatar
Ammulu_M
Helper I
2 years ago

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. i have multiple files which results the agent performnces for different KPI's . created relation from main file to all the files. and now applying rls on the main file emp id.

 

I have team rank calculated for each KPI. now it was changing after the rls.

Before RLS my team ranks and lob ranks for one agent


After RLS team rank and lob rank for same agent


please help me with that. 

 

Data Protection
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

12 Replies

  • raji_n's avatar
    raji_n
    Resolver II
    2 years ago

    Ammulu_M I think you have to use another fact table for your ranking, that way RLS wont affect the ranks.

      • raji_n's avatar
        raji_n
        Resolver II
        2 years ago

        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.