topic Section access is not working in QlikView

Section access is not working

Wed, 18 Apr 2012 15:35:14 GMT

Hi,

I am trying to set section access on one of the document to reduce data per user.

I have added the following to the script

Section Access;

LOAD NTNAME,

NTDOMAINSID,

[ACCESS],

MANUFACTLBL

FROM

C:\QlikviewReports\Sourcedocuments\SectionAccess\ByBrandNameMangers.xlsx

(ooxml, embedded labels, table is Sheet1);

Section Application;

Where I want to reduce data based on the MANUFACTLBL.

I have also Intialated the Data Reduction Based on section access on the Document properties/Opening tab.

and on the scurity I have checked the box reduce data.

When I try to access the document using one of the users it asks me for UserID and Password and when I enter my QV User ID and Password it doesn't recognize me.

Is there anybody can help?

Thxs

Section access is not working

Wed, 18 Apr 2012 16:12:15 GMT

Is there anything I need to do.?

I am trying to get rid of the IserID and Password..

how can I link it to the computer UserID and Password? as It is working fin eon another report but don't know how did they do it.

Thxs

Section access is not working

jonathandienst — Wed, 18 Apr 2012 16:25:28 GMT

I suspect that the user's login is not one of those on the spreadsheet, so it cannot find the NTNAME and degrades to a username and password login. You have not supplied the username/password option on your section access, so it fails.

Alternatively, the user is on a different domain, so the domain SID is causing access to be blocked.

Hope that helps

Jonathan

Section access is not working

Wed, 18 Apr 2012 18:01:40 GMT

I am working remotly on a server and I have logged using one of the names on my excel file.

and when logging to the access point to view the report i use the same userID.

Any suggestions on how to fix that?

Regards

Section access is not working

Thu, 19 Apr 2012 14:39:53 GMT

I have added all the possible users to the excel file but still not able to do it.

Thxs