Forum Discussion
Solved
RLS To Impact only One Fact Table
Hello, I am working to apply Dynamic RLS to my current report. I have a User table that includes users' role in the company. I also have many fact tables from various parts of the organization, a...
One thing I can think of is to make a copy of the dimRoster and link it only to the factFraud table. Then you can apply the RLS to the copy of the dimRoster and it will flow only to the factFraud. You could make the dimRosterCopy really narrow so it only has the fields you need for the filtering and the relationship. You can also hide the table in the model so people don't see two dimRoster tables.
Yeah, it's not ideal but I couldn't think of another way to do it. Could come in handy if there ends up being other items that need RLS applied to them. You will already have the table you need in place.