1 of 1 people found this helpful
The simple answer is "No".
Each view is based on a particular datasource,
and there's (almost) no way to make this "dynamic".
I could imagine the scenario in which Tableau is passing
(via Initial SQL datasource option) a value of USERNAME()
to a Store Procedure of the datasource's underlying DBMS.
The SP would generate a "dynamic" view -- with the same
field names' data types and aliases -- for Tableau to use it as a DS.
A manageable alternative (imho) would be using different views
for each LOB and Sheet Swapping technique on a dashboard --
depending on a properly assigned User Filter(s).
Thanks a lot Yuri. I am doing the same, creating separate views for different datasources.