1 Reply Latest reply on Oct 12, 2018 2:57 PM by patrick.byrne.0

    Userfilter on specific column

    Rajashmita Kar

      Hey guys,

       

      I have a requirement to implement user security based on Company Code in my dashboard. I have scenarios where some user should be able to see all company code but some user should have specific company code access. So I have created two  different DL for the same and restricted user with specifc company code(user security table).  i am writing calculation like

      if ISMEMBEROF('group1')  then true

      ELSEif ISMEMBEROF('group2') AND  [username]=ATTR([User Security].[Sso]) then true

      else false end

       

      but this works only if i add company code on my view otherwise it is not working and user able to see all data. Is there any solution for it?