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:
- 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.
- extract has millions of records and entitlement file has 500+ lines
Kindly share your recommendations/suggestions. Thanks in advance!
@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