I am trying to establish some speicifc RLS like below:
Based on the User logged in (who opens the Report Server URL), I need to filter the visuals to show all the records of Region that user belongs to.
Example, in my below screen shots, I have two table visuals built on Adventure Workd DW - Dim Customer, Dim Geograpy and FactInternetSales.
Now when a user (Aaron Kumar, second in the screen shot) opens this report, he should be able to see all the records belonging to Regoin = United States. If user (Aaron King, first in the screen shot) opens this report, he should be able to see all the records belonging to Region = Canada.
I have tried to add a Role like shown below, two rules for one role. But really dont understand how to achieve this.