topic Re: Section Access in QlikView

Section Access

trpatel123 — Wed, 08 Jul 2015 10:14:57 GMT

I want to give access of QlikView Application to three persons and want to restrict all others.

I don’t want to set up any ID and Password but instead want to use NTNAME which I have done as below (i.e. Once user logged in using windows ID and Password can access the application from access point)
I also don’t want to limit access to any user on Field Level. (i.e. All users can see all data)
All three users have been authorised to access the documents from access point.

SECTION ACCESS;

LOAD * INLINE
[
ACCESS,NTNAME

ADMIN, DOMAINNAME\ABC

USER, DOMAINNAME\XYZ
USER, DOMAINNAME\PQR
];

SECTION APPLICATION;

Sales:

Load * Inline

[

Region, Sales

North, 100

South, 90

East, 150

West, 125

];

Reload of this document is getting failed. What I am doing wrong here?
Is the above method is correct? or I am missing something !

Re: Section Access

krishna20 — Wed, 08 Jul 2015 10:25:33 GMT

Hi,

what error it's throwing? disable the option close when finished and see.

Re: Section Access

trpatel123 — Wed, 08 Jul 2015 10:30:47 GMT

(2015-07-08 10:58:42) Error: Document open call failed. The document might require username and password.

(2015-07-08 10:58:42) Information: Attempted to load the document without data.

(2015-07-08 10:58:42) Error: The document failed to open.

(2015-07-08 10:58:43) Information: Closed the QlikView Engine successfully. ProcessID=3944

(2015-07-08 10:58:43) Error: Document could not be opened

(2015-07-08 10:58:43) Information: Closed the QlikView Engine successfully. ProcessID=3944

I think I have to setup something to allow the QDS service permission to open the document to allow reloading to run.

Re: Section Access

krishna20 — Wed, 08 Jul 2015 10:35:16 GMT

Hi,

Is the APP running successfully when you reload it manually?Please check it once.Then we can check the settings in QMC part.

Re: Section Access

awhitfield — Wed, 08 Jul 2015 10:37:51 GMT

You need to add the QV service credentials to the SECTION ACCESS script as ADMIN

HTH Andy

Re: Section Access

trpatel123 — Wed, 08 Jul 2015 10:38:00 GMT

1) Application without Section Access is running and reloading successfully.

2) If I use ID and PASSWORD in section access instead of NTNAME, running/reloading successfully.

Re: Section Access

krishna20 — Wed, 08 Jul 2015 10:45:08 GMT

Okay.Then give your service Account Username and Password like in attached images.

Re: Section Access

trpatel123 — Wed, 08 Jul 2015 10:46:47 GMT

How? Can you provide some more information on this?

Re: Section Access

krishna20 — Wed, 08 Jul 2015 10:51:27 GMT

Hi,

your Section Access Script might be like this.

Section Access;

ACCESS	NTNAME
ADMIN	DOMAINNAME\ADMIN
USER	DOMAINNAME\KRISHNA
USER	DOMAINNAME\KANE
USER	DOMAINNAME\JOHN

Section Application;

Go to document properties-> opening-> Initial Data reduction based on section Access should be enabled.

Re: Section Access

vardhancse — Wed, 08 Jul 2015 10:53:10 GMT

in QMC task->Distribution->we can select names users and can give the 3 users name.

So that once task is successful, then the dashboard will be access to only the give 3 people.

Re: Section Access

Anonymous — Tue, 06 Oct 2015 22:38:32 GMT

I followed all of these suggestions and kept having problems.

In the end the simple answer was to include the QV service credentials as indicated by Andy...

SECTION ACCESS;
LOAD *
INLINE [ ACCESS, NTNAME
ADMIN, domain\qv_service_account_id
ADMIN, domain\developer_id

USER, domain\regular_user_id ];

SECTION APPLICATION;

However (and maybe it is obvious to everyone else?), it is necessary to reload the document under the credentials of an existing user with the ADMIN capabilities already in the section list and save the QVW so that the server service account is now in the file.

I didn't need to bother with any other settings than this.