1 Reply Latest reply on Apr 16, 2018 2:55 PM by Jeevan Krishna

    Apply territory based security on data

    Evgeniy Soytonen

      Hi, everyone.

      I have a extracted sales data table from BW with 3 levels of sales:
      Sales org- Sales office - Sales group.

       

       

      And I want to grant access to users basing on territory model:

      UserIDSales orgSales officeSales groupUsername()
      SalesAdmin11000**user1
      SalesRep11000100Auser2
      AreaSalesManager11000200*user3
      AreaSalesManager21000300*user4
      SalesRep21000300Buser5
      SalesRep31000300Auser6
      TerritoryManager1000**user7

       

      * - all available values

       

      And all my sales data contains Sales record like

       

      DocIDSales OrgSales officeSales groupNetValue
      900011000100A530$
      900021000100B560$
      900031000200A370$
      900041000300A960$

       

      So for user1: all documents should be available 90001 - 90004

      user2: 90001

      user3: 90003

      user4: 90004

      user5: n/a

      user6: 90004

      user7: 90001 - 90004

       

      Is it possible to implement such a model for row security in Tableau?