Forum Discussion
Solved
Ranking while using RLS
Hey all, bit of a tricky one for me today. I have two tables, a username/email table with unique records and a fact table; the user table filters the fact table. I have a role in my report tha...
Yes, you create a duplicate of your fact table that is not impacted by RLS and has all identifiable/sensitive information removed/summarized away.
What's the actual issue? This is how RLS works. You can't have your cake and eat it too.
I'd just like to know if there's a way to achieve the desired result of ranking for all, maybe by duplicating the fact table? I understand that's how RLS works 🙂
Yes, you create a duplicate of your fact table that is not impacted by RLS and has all identifiable/sensitive information removed/summarized away.