-
1. Re: Data Source Filters - Filter based on Role
Matt LuttonJan 9, 2014 12:05 PM (in response to Vinod Maharana)
I'm not sure if you can apply something like this or not, but I recalled a similar problem that had come up a while back:
-
2. Re: Data Source Filters - Filter based on Role
Robert MortonJan 9, 2014 2:28 PM (in response to Vinod Maharana)
Hi Vinod,
Consider using the ISMEMBEROF() user function in Tableau to determine the group membership of that user as defined on Tableau Server. Here's the documentation for Tableau user functions: http://onlinehelp.tableausoftware.com/current/pro/online/en-us/help.htm#functions_functions_user.html
I hope this helps,
Robert
-
3. Re: Data Source Filters - Filter based on Role
Vinod Maharana Jan 13, 2014 9:14 AM (in response to Robert Morton)Thanks for the suggestions. I ended up using a table instead. I create a user mapping table like below :
user_employee_id
user_type
adtia
adtia
albrtt
albrtt
apabr
apabr
mahar
1LR
narma
1LR
grimm
grimm
becma
becma
hrmer
hrmer
jeffrt
jeffrt
"1LR" are all users that are admin. Used user_employee_id to create data-source filter. Joined this table to mail Table on user_type, instead. All data that has admin access gets stored once with user_id "1LR".