0 Replies Latest reply on Nov 12, 2018 10:25 PM by moulika gattu

    Automate the process of giving a persons access to a group of people

    moulika gattu

      Hi ,

       

      I have a calculation in tableau which defines the level access of persons who login. The script has hardcoded names. My requirement is to automate i.e to remove the hardcoded part of the script.

       

      Scenario:

       

      I have some 5 groups in tableau server which represent hierarchy levels( Bizops-Level 3, 4, 5, 6, 7). I have attached the table structure of my dashboard.

      In The calculation script

      • first we are checking for IsMemberOf and then checking the level Email names and returning a Y or N as results.

      eg:

      IF (ISMEMBEROF('Admin'))
      then
      if  ([Level3 Email] = 'Sri' or [Level3 Email] = 'Mou')
      Then
      "Y"
      ELSE 
      "N"
      END
      ELSEIF (ISMEMBEROF('BizOps - Level 3'))
      then
      if ([Level3 Email] = 'Sri' or [Level3 Email] = 'Mou')
      Then
      "Y"
      ELSE 
      "N"
      END
      ELSEIF (ISMEMBEROF('BizOps - Level 4'))
      then
      if (USERNAME() = 'Nihal' or USERNAME() = 'srinika' or   USERNAME() ='krithika'   //** a group of usernames are given access at 'mnop'. so when 'abc' login he can see 'mnop'  level data **//
      then
      if  [Level4 Email] = 'Kamala'
      Then
      "Y"
      ELSE 
      "N"
      END

      ELSEIF  (USERNAME() = 'Mohith' or  USERNAME() ='Neha' or USERNAME()='vamshi' )

      then

      if [Level5 Email] = 'NarsingRao'

      Then

      "Y"

      ELSE 

      "N"

      END

       

      ********************************************************

      In The script we can see that Levelx Email values are hardcoded. I have to remove these hardcoded values with the help of tableau and if any new persons joins into a group to whose level that person should get access must be defined.

       

      Please help me with ideas to achieve.

       

      Thank you!