1 Reply Latest reply on Feb 5, 2019 12:57 PM by Santiago Sanchez

    Store Procedure vs Extract Row Level Security

    Kim Wee

      Hi all,

       

      I've been using Extract Row Level Security. It been working well with occasionally long extract time and failed extract.

      Recently I've been ask to create a new hierarchy level based on multiple field, which I think will crash the extract because of the different combination.

      I was looking for an alternative and store procedure had been pop up in my search.

       

      Can someone tell me what is the advantages and disadvantages of the both methods?

       

      I'm using a Microsoft SQL database and Tableau Server V10.5. Will be upgrading to 2018.3 (or 2019.1 when it release) in the next couple of weeks.

       

      Thanks in advance.