1 Reply Latest reply: May 4, 2015 12:11 PM by Shiva Reddy RSS

    section access/application problem

      Hi,
      I have a problem with section application.
      I have 2 filters:

      In the section access:

      Filter the "Pub_Company" (each ntname get permissions to different Pub_Company name)

      In the section application:

      Filter by tabs.(each ntname get permissions to different tabs in the document)

       

      The Pub Company filter dosn't work:

      If i filter "pub_company" for one ntname, all the other ntnames can't see the "pub_company" too.

      Do you know what is the problem?

       

       

      SCRIPT:

       

      section Access;

      LOAD UPPER(ACCESS) AS ACCESS,

           UPPER(NTNAME) AS NTNAME,

           PUBCOMPANY as [Pub_Company]

      FROM

      [C:\Users\innas\Desktop\Permissions.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      SECTION APPLICATION;

      LOAD UPPER(NTNAME) AS NTNAME,

           UPPER(SH01) AS SH01,

           UPPER(SH02) AS SH02,

           UPPER(SH03) AS SH03,

           UPPER(SH04) AS SH04,

           UPPER(SH05) AS SH05

      FROM

      [C:\Users\innas\Desktop\Permissions.xlsx]

      (ooxml, embedded labels, table is Sheet1);

       

      dim_publishers:

      LOAD * Inline [publisher_id,Pub_Company]

      1,ARG

      2,SPA

      3,DSP

      4,DDS

      ];

       

       

       

       

      sheet1:

      ACCESSNTNAMEPUBCOMPANYSH01SH02SH03SH04SH05
      USERCYDOORCOM\aARG11000
      USERCYDOORCOM\cSPA10011
      USERCYDOORCOM\cDSP 10001
      USERCYDOORCOM\dDSP 11101