1 of 1 people found this helpful
Are you on a model of Tableau that allows for the use of the guest user account? This account could be your default account but when a user logs in they see their may be a way to provide the user provided view. The guest account would have to exist as a option for the user filter as well.
I do not know of a way to accomplish this without that sort of Tableau Server license though. I have moved this thread the Server Administration area for further discussion.
I have achieved the scenario by creating dynamic views in initial sql based on the user that has logged in. The dynamic views contains the database level security.
In the views I have included a flag column.
Then a calculated field where if flag=1 the apply user filers(user filters combined using AND) else do not apply user filter.
THEN [Country_user_filter] AND [LS_user_filter] AND [Territory_user_filter]