7 Replies Latest reply on Apr 20, 2018 3:22 PM by vishnukumar moolapremchandran

ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

Jason Nichols Apr 25, 2017 6:56 AM

I have a workbook where I recently added the ISMEMBEROF() function to provide some row level security for some of the data. The function works properly; however, when I add someone to the specific user group on Tableau Server, they are not able to see the data at first. After I re-publish the workbook, the new user who was added to the group is now able to see the data filtered by the ISMEMBEROF function. Am I required to re-publish the workbook every time the members of the group changes? Or am I doing something wrong when setting up the function?

Thanks,

Jason

1. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

Jeff Strauss Apr 25, 2017 9:30 AM (in response to Jason Nichols)

I haven't seen an issue with ismemberof(). Are you using multiple AD domains? Check out this KB article. IsMemberOf Function Returns Wrong Results When Filtering User Accounts | Tableau Software
Like Show 0 Likes(0)

Actions
2. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

Jason Nichols Apr 25, 2017 9:36 AM (in response to Jeff Strauss)

Thanks for your reply Jeff. I am not using multiple domains. The function works perfectly fine for the new users when I republish the workbook after the new users have been added to the group. It just does not seem to automatically update for some reason.
Like Show 0 Likes(0)

Actions
3. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

Jeff Strauss Apr 25, 2017 10:11 AM (in response to Jason Nichols)

well. It does seem to be a problem as I just ran a simple test with my on-premise TS version 10.1.3 and see the same behavior as you. And since I did it on a dev environment I was able to do a tabadmin restart and this seems to have at least provided a fix for this one instance. But it should be immediate, maybe it's being cached somewhere.

Can you go open a support case?
Like Show 0 Likes(0)

Actions
4. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

Jason Nichols Apr 25, 2017 12:16 PM (in response to Jeff Strauss)

Thanks Jeff. I have opened a case.

Thanks again for doing some checking on your end, good to know I'm not crazy!
Like Show 0 Likes(0)

Actions
5. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

Jeff Strauss Apr 25, 2017 12:46 PM (in response to Jason Nichols)

cool. Please be sure to post back to the forum after you hear back on your case.
Like Show 0 Likes(0)

Actions
6. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

Zach Schmitt Jun 27, 2017 6:31 AM (in response to Jason Nichols)

Jason,

Would you mind posting the solution to this case? I am having the same issue.

Thank you!
Zach
Like Show 0 Likes(0)

Actions
7. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

vishnukumar moolapremchandran Apr 20, 2018 3:22 PM (in response to Jason Nichols)

I'm having the same problem in Tableau 10.4 server version. Everytime I have to republish to make it work. If someone resolved this, please post!..

For ruling out caching issues, I did a tabadmin stop,clear cache and start the server, but it did not fixed the issue. I tried this with a workbook and also a datasource , both has the problem.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

1. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

2. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

3. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

4. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

5. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

6. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

7. Re: ISMEMBEROF() - need to re-publish workbook every time I add a user to the group?

Actions

More Like This