3 Replies Latest reply on Jan 13, 2014 9:14 AM by Vinod Maharana

    Data Source Filters - Filter based on Role

    Vinod Maharana

      In one of my tableau connection data is filtered based on the username. For which I have added this filter :

       

      [user_employee_id]= USERNAME()

       

      But there are exceptions too, for example for superusers (10% of the population) will have full access.  So I need a data filter someting like this :

       

      [user_employee_id] = (iif( USER_TYPE = 'Admin', 'XXX', USERNAME() )

       

      I need this USER_TYPE to come from Tableau, maybe based on some roles or permissions. This value I do not want to get from database.