I have back end data source as Oracle and VPD has been implemented on the database. I am trying to have the VPD logic implemented in Tableau 9.3 version via the Initial SQL query, but its not filtering for any user. The dashboard I created has 4 tables with relevant joins.
The report runs fine. Then I go to Data-àmy Connection Name-àInitial SQL Query and enter the code below
I then run the report and publish to server. Then login with different users and the row level filter in not being applied. Can you please guide. Has anyone worked on a similar requirement. Please advice.