2 Replies Latest reply: May 18, 2016 6:55 AM by Christian Nagelschmitz RSS

    Section Access and reduction over 2 fields - ADMIN vs USER problem on the Access Point

    Christian Nagelschmitz

      Hello,

       

      I have successfully developed an application where Section Access is used, to reduce data over two fields.

       

      From prior discussions I understood that there are no ADMIN users on the Access Point, these ADMIN lines in Section Access should be ignored on the AP and are just for the QlikView Client.

       

      My problem now is, that these information about the ADMIN on the AP does not come true.



      // sales data

      Daten: 

      LOAD DKUN_VERTRIEBSLEITER_ID & '|' & DKUN_VERKAUFSORGANISATION_ID as AuthID,

                 DKUN_VERKAUFSORGANISATION_ID,

                 DKUN_VERTRIEBSLEITER_ID,

                 UMSATZ

      FROM

      [C:\Users\ACB\Desktop\Section Access Test\Daten.xlsx]

      (ooxml, embedded labels, table is Tabelle1);

       

       

      // user authorization table

      Source_Authorization_Table:

      LOAD VERTRIEBSLEITER & '|' & VKORG as %AuthID,

                 USER,

                 VERTRIEBSLEITER,

                 VKORG

      FROM

      [C:\Users\ACB\Desktop\Section Access Test\Source Authorization Table.xlsx]

      (ooxml, embedded labels, table is Tabelle1);

       

      // connection between the sales data and the authorization table

      Connection_AuthTable_Data:

      LOAD DKUN_VERTRIEBSLEITER_ID & '|' & DKUN_VERKAUFSORGANISATION_ID as AuthID,

      DKUN_VERTRIEBSLEITER_ID & '|' & DKUN_VERKAUFSORGANISATION_ID as %AuthID Resident Daten;

        

      LOAD DKUN_VERTRIEBSLEITER_ID & '|' & DKUN_VERKAUFSORGANISATION_ID as AuthID,

      '<ANY>'   & '|' & DKUN_VERKAUFSORGANISATION_ID as %AuthID Resident Daten;

       

      LOAD DKUN_VERTRIEBSLEITER_ID & '|' & DKUN_VERKAUFSORGANISATION_ID as AuthID,

      DKUN_VERTRIEBSLEITER_ID & '|' & '<ANY>'  as %AuthID Resident Daten;

        

      LOAD DKUN_VERTRIEBSLEITER_ID & '|' & DKUN_VERKAUFSORGANISATION_ID as AuthID,

      '<ANY>'   & '|' & '<ANY>'  as %AuthID Resident Daten;

       

      Section Access;

      LOAD * INLINE [

      ACCESS, NTNAME, USER

      USER, QTSEL\ACB, USER1

      USER, QTSEL\QWE, USER2

      USER, QTSEL\QWS, USER3

      USER, QTSEL\QWD, USER4

      ];

      Section Application;



      This script works fine, the problem which I have comes when I put a ADMIN User in the Section Access:

       


      Section Access;

      LOAD * INLINE [

      ACCESS, NTNAME, USER

      ADMIN, QTSEL\ACB, USER5

      USER, QTSEL\ACB, USER1

      USER, QTSEL\QWE, USER2

      USER, QTSEL\QWS, USER3

      USER, QTSEL\QWD, USER4

      ];

      Section Application;


      In the QlikView Client I am identificated as ADMIN and see everything which is linked to USER5 - which is correct.


      BUT when I put the application on the server and enter the Application, I still see the same view as of the QlikView Client with USER5 and NOT USER1 - as I thought.


      Can anybody give me a clue?

       

      Kind Regards,

       

      Christian