3 Replies Latest reply: May 4, 2017 7:27 AM by Anitha Mohanraj RSS

    Section Access for only one tab

    Anitha Mohanraj

      Hi,

      I have a document with 3 tabs, in which one of the tab needs to be restricted and should be available only for a set of users, available in an excel sheet. Additionally, only one group of the users that is available in the excel should get the access (this excel has other purposes for other dashboards).The other 2 tabs should be available to ALL users.

      The Excel looks like:

      NTNAMEACCESSBUDGETACCESS
      ABCUSERYes
      BCDUSERNo

       

       

      So, here is what i did after loading the excel:

      SECTION APPLICATION;

      LOAD * INLINE [

      BUDGETACCESS,SH07

      YES, 1

      NO, 0

      ];

       

      Also, on the restricted tab, i have enabled conditional show with "= sum(SH07)>=1".

      I have checked the appropriate checkbox in the Settings/opening.

       

      Section access.GIF

      I have ensured in QMC, the task associated has the section access check box enabled.

       

      With all this, the restriction is not working. Also, for the people who are not in the excel are not able to see the entire dashboard. Ideally, they should be able to see the other 2 tabs.

       

      What am i doing wrong?!

       

      Thanks,

      Anitha

        • Re: Section Access for only one tab
          Krishnapriya Arumugam

          Section Application and Section Access script should have below details

           

          1. NTNAME/USERID

          2. ACCESS

          3. Reduction Fields

           

          in Your Example the table should look like

           

          SECTION APPLICATION;

          LOAD * INLINE [

          NTNAME, ACCESS, BUDGETACCESS

          ABC,USER,YES

          BCD,USER,NO

          ];

           

          Use this Budget Access field to Show/Hide the Sheet.

          • Re: Section Access for only one tab
            Peter Cammaert

            Section Access restricts access to your document to those users that are explicitly listed in your Section Access table. No one else will get in, UNLESS you add a line with a * in the NTNAME field and a NO in the BUDGETACCESS field.


            Note that if you are not using Data reduction, but only data selection in the settings on the Document Properties->Opening tab, you will not protect your document in any way. Anyone who can add a listbox with the BUDGETACCESS field can select the YES value because it will still be available.


            The difficulty with Section Access explanations is that they never describe configuration and operation in its entirety. It's way simpler for you to post an example document, and for us to show what we mean.