Skip to main content

I have 2 data source. 1 is excel sheet which has entitlement details (userID, role, region) another is an extract of a table from Database. My requirement is, when user access the workbook, based on the user role the data should be displayed. I am able to achieve this with a filter on Username()=userID calculation only for lower-level roles rows. Now, If a user is at a higher level in role. he/she should be able to see all the regions/global data. the filter should not be applied for the users with higher roles. The challenge is, I can't duplicate the rows for each region for a every high level user in my entitlement file. Based on the role, I should either display 1 region per user or multiple regions per user.

Note:

  1. We can't do any changes to the extract sourcing from database. Changes (other than associating all countries to every higher level role user) can only be done to entitlement file.
  2. extract has millions of records and entitlement file has 500+ lines

Kindly share your recommendations/suggestions. Thanks in advance!

1 answer
  1. Aug 21, 2024, 9:17 PM

    @Krishna Moorthy Purru​ 

    Hi, you may take a look of:

    https://www.tableau.com/learn/whitepapers/row-level-security-entitlements-tables

     

    Probably, the best option would be to create a group in Tableau for the higher roles, and then use something like:

    ISMEMBEROF("High Roles Group") OR USERNAME()=[userID]

     

    If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.

     

    Regards,

     

    Diego Martinez

    Tableau Visionary and Forums Ambassador