Section Access

[trpatel123]

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

1. 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)
2. I also don’t want to limit access to any user on Field Level. (i.e. All users can see all data)
3. 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

];

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

[krishna20]

Hi,

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

[trpatel123]

(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.

[krishna20]

Hi,

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

[awhitfield · Accepted solution]

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

HTH Andy

[trpatel123]

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.

[krishna20]

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

[trpatel123]

How? Can you provide some more information on this?

[krishna20]

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.

[vardhancse]

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.