Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
(ooxml, embedded labels, table is Tabelle1);
// user authorization table
Source_Authorization_Table:
LOAD VERTRIEBSLEITER & '|' & VKORG as %AuthID,
USER,
VERTRIEBSLEITER,
VKORG
FROM
(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
as I can see the above section access iis only NTname security for users access.
You have not mention two fields on which you want to Reduce Data.i
Think section access code would be like below
Section Access;
Load
upper(ACCESS) as ACCESS, upper(NTNAME) as NTNAME, upper(DKUN_VERTRIEBSLEITER_ID &'|'&DKUN_VERKAUFSORGANISATION_ID) as AuthID;
LOAD * INLINE [
ACCESS, NTNAME, DKUN_VERTRIEBSLEITER_ID ,DKUN_VERKAUFSORGANISATION_ID
ADMIN, QTSEL\ACB, Somevalue,Somevalue
USER, QTSEL\ACB, Somevalue,Somevalue
USER, QTSEL\QWE, Somevalue,Somevalue
USER, QTSEL\QWS, Somevalue,Somevalue
USER, QTSEL\QWD, Somevalue,Somevalue
];
Section Application;
Thanks Sunil for your fast reply.
I have used the article to implement Section Access:
Data Reduction Using Multiple Fields
So in the front I am using just one field to reduce data, but in the background there is a mapping table which restrict both fields DKUN_VERKAUFSORGANISATION_ID and DKUN_VERTRIEBSLEITER_ID.
I am just wondering about the usage of ADMIN vs USER, especially on the Access Point.
Do you have any idea about this issue?