2 Replies Latest reply on Nov 19, 2015 6:16 AM by Sesh Reddy

    row level security and hide filters

    Sesh Reddy

      Hi,

      I'm building a row level security model. Based on user login details, the required dataset will be fetched from data source.

      If I use using live connection. It works fine as below.

       

      Here is the example. The user_name is nothing but the login credentials.

       

      User_name OrderID SaleAmount

      Sesh            1             10

      Divs             2              20

      When Sesh login, he should be allowed to see only his row.

       

      I've applied the filter as below.

       

      Edit Data source filters -> [User_name]=USERNAME()


      It works, however - the filter gets applied on source query. Since it's heavily used table, it has to hit source every time a user runs the query.

       

      I'd like to fetch all the data once and then apply the filters, I could avoid hitting the database several times.

       

      I thought I'd use a calculated column and apply a filter in a tableau report. However, the filter will be displayed to user, which is annoying.

       

      Can I hide the filter completely from user ?  Or is there any other methodology to use this.

       

      Totally Other question - Can I schedule the EXTRACT

       

      Cheers

      Seshi