1 Reply Latest reply: Jun 20, 2013 10:36 PM by Michael Jordan RSS

    Section access to provide access to all data to a few users

      Hi,

       

      I am trying to create a document with section access. I am using a reduction field to reduce the data on inital load based on user login. I need a way to display all the data to most of the users and only selected data to a few users. For example:

       

      I am putting in section application section the following:

       

      section access;

      Directory $(vQVDPath);

      LOAD NTNAME,

           ACCESS,

           GROUP

      FROM

      [Access Permissions.xlsx]

      (ooxml, embedded labels, table is [User-Group]);

       

       

      section application;

      Directory $(vQVDPath);

      LOAD GROUP,

                Currency

      FROM

      [Access Permissions.xlsx]

      (ooxml, embedded labels, table is [Group-Permissions]);

       

      In the Group-Permissions sheet, I have the following:

       

      GROUP          CURRENCY

      GRP1               USD

      GRP2               GBP

      GRP3               JPY

      GRP4                ????

       

      My question is on group 4. My data has more than 20 currencies. I want GRP4 to be able to view all these 20 currencies and GRP1, GRP2, GRP3 only 1 currency each as per the table above. I have tried using * but that essentially means that GRP4 will be able to access only USD, GBP and JPY. I tried leaving it blank but in that case GRP4 doesn't get access to any currency.

       

      Please let me know if there is a way to solve this.

       

      Thanks.

        • Re: Section access to provide access to all data to a few users
          Michael Jordan

          Hi,

           

          You can use all the 20 currencies in ur Section Application Against GRP4,

           

          See Attached Example

           

          LOAD * INLINE [
              Value, Currency
              1000, USD
              2000, GBP
              2500, JPY
              3000, INR
              2200, SGD
              1400, DNR
          ];

          Section Access;
          LOAD * INLINE [
              ACCESS, USERID, PASSWORD, GROUP
              User, ABC, *, GRP1
              User, PQR, *, GRP2
              User, XYZ, *, GRP3
          ];
          Section Application;
          LOAD * INLINE [
          GROUP, Currency
          GRP1, USD
          GRP2, GBP
          GRP3, USD
          GRP3, GBP
          GRP3, JPY
          GRP3, INR
          GRP3, SGD
          GRP3, DNR
          ];

           

          Note:- While using Section Access rather than using "Initial data reduction based on section Access", use "Initial data selection based on Section Access" until ur testing is complete.

           

          Thanks