1 Reply Latest reply on Jun 30, 2018 6:19 AM by daniel.andell

    Row security performance

    daniel.andell

      I have a few levels of detail in my row security. to cover alol possible combinations I have created one row per combination for each user. User 2 for example has one row for south product 1 and one for product 2 etc.

       

      I will potentially have 100+ users in this security file. Since the number of users add rows to my data I would like to do this setup best way. I have added top level users to a group who should have access to all data. this eliminates some users.

       

      1. Will number of users affect the performance for each user or only for me as an admin?

      2. Would you recommend me to create a calculation to check level 1 and level 4 to limit the number of columns

      3. Is there another way of keeping high performance and still have this level of security?

       

       

      Level 1 has four options

      Level 2 and 3 has 20-30 choices

      Level 4 has three options

       

       

      User      Level 1    Level 2    Level 3  level 4

      user 1    Europe

      user 2    Europe   Germany

      user 3    Europe   Germany  North

      user 3    Europe   Germany  South       Product 1

        • 1. Re: Row security performance
          daniel.andell

          Just wanted to help others by saying that we solved it by creating a user in the row security called all access. Then we gave this user all combinations. Now we added another formula looking for all access users. If they are all acces they should use all access user.

           

          then we just used this formula username()=calculation and added it to the file