Assuming you don't wanna publish 2 seperate reports and associating each DL (user group) with one of these reports. You can take a simple approach you can use a reference table let's say RESTRICTION there should be 2 columns EMP_ID (which tableau captures as username) and Region. Now join this with your fact table. And use data source filter over that restriction table with condition as EMP_ID = USERNAME(). So suppose I'm a a subordinate you did an entry in RESTRICTION table as (101, DELHI) and if you are a manager you did an entry for yourself as (102, [list of state from India]) now that list of state you can easily get from your location dimension table. This would be very flexible in several cases like you are checking data for your manager who is in Australlia you can easily delete your entry from restriction table and re insert states from Australlia under your sso. You would get the desired dataset instantly.