1 Reply Latest reply on Nov 18, 2016 3:48 AM by lenaic.ridinger

    Oracle VPD and Tableau Server 9.3 (Initial SQL Query)

    suresh matta

      GM All,

      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.

      tables.png

      1. The report runs fine. Then I go to Data-àmy Connection Name-àInitial SQL Query and enter the code below

       

      tables2.png

      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.

       

      Tableau Server Version 9.3

      AD authentication

      Oracle 11g (AD Authentication)