topic Re: Help for using section access with sharepoint list data in QlikView

Help for using section access with sharepoint list data

Sat, 18 Oct 2014 13:06:22 GMT

Hi ,

I have created a report in qlikview with all user's entry-exit times to show them how many hours they work and how many hours they have delay per month, now I wanna publish the report in our sharepoint portal but each of them is suppose to see just her/his report, means when they log in with their usernames and password, the report has to show just those information which is related to them . I made a list in sharepoint (as you can see in the picture) which user's access information and add the below script part in my report script , but it doesnt work did I miss s.th?

Thanks

PersonelInfo:

LOAD * INLINE [

RowNumber,PersonelId,ows_Author

1,9,9;#Mohsen Kermani

2,10,10;#Mehdi Etehadi

3,13,13;#Mis Bahrami

4,30,30;#Mis Shahi

5,38,38;#Mis Aqabeyki

];

AccessInfo:

LOAD ows_NTNAME as NTNAME,

ows_SAUSER as SAUSER,

ows_TABACCESSSHEET1 as TABACCESS.SHEET1,

ows_TABACCESSSHEET2 as TABACCESS.SHEET2,

ows_FIELDACCESSDIVISIONFILTER as FIELDACCESS.DIVISIONFILTER,

ows_Title as ACCESS

FROM [http://10.130.11.3/_vti_bin/owssvr.dll?Cmd=Display&XMLDATA=1&RowLimit=0&List={1D93957E-BD48-428A-B599-3F2D811982C3}&View={61BFBA78-3020-4081-B475-FA0EDBBB944D}] (XmlSimple, Table is [xml/data/row]);

Section Access;

SATABLE:

LOAD

ACCESS,

NTNAME,

SAUSER

Resident AccessInfo;

Section Application;

DocSecurity:

LOAD

SAUSER,

TABACCESS.SHEET1,

TABACCESS.SHEET2,

FIELDACCESS.DIVISIONFILTER as PersonelId

Resident AccessInfo;

Re: Help for using section access with sharepoint list data

kuba_michalik — Sat, 18 Oct 2014 22:30:39 GMT

Have you enabled Initial Data Reduction Based On Section Access in Document Properties : Opening ?

Also, if you want those stars to work (I assume they are to mean "everything"?), you need to put

STAR is *;

before loading the DocSecurity table. Otherwise it will look for users who have literal stars as their PersonelID.

It is prudent to put

STAR is;

right after loading this table, to turn it off again (it will remain in effect for already loaded data).

Re: Help for using section access with sharepoint list data

Sun, 19 Oct 2014 05:56:23 GMT

Hi Jakub ,

Yes , due to my searches for sloving my problem I have enabled Initial Data Reduction Based On Section Access in Document PropertiesmOpening tab and also I added STAR is * in the right place but it still doesnt work ! I think there is something about table relations or like this . and it's interesting that the filter seems to work when a user run the report exe file , but any effect when try to open it on the web ! how they can be different?!

Re: Help for using section access with sharepoint list data

kuba_michalik — Sun, 19 Oct 2014 09:20:22 GMT

Do you mean the Section Access works when opening qvw app in the QlikView desktop locally, but doesn't when opening it on the Access Point? That would be very strange. Just to be sure, by not working you mean just the filter not working, not the app failing to open at all on the Access Point?

Re: Help for using section access with sharepoint list data

Sat, 01 Nov 2014 09:01:38 GMT

Hi Jakub

Yes I mean just the filter not working.