topic Re: Section access and data reduction in QlikView

Section access and data reduction

Wed, 02 Nov 2011 15:22:18 GMT

I am currently learning how to work with section access and I have a question about data reduction. As I understand it, it is possible with section access to give the user access to specific parts of the document data according to his userID. An user with administrator rights will always have access to all the data. However I cannot see any difference in behavior if I don't check the "Initial data reduction based on section access". Is it normal or did I miss something? I understand the point of the "initial data reduction" checkbox but I do not understand the goal of implementing a section access defining values of a given field available to a given user without checking the box. Can someone give me some explanation about that?

Re: Section access and data reduction

Wed, 02 Nov 2011 17:47:48 GMT

Hi George,

Section Access just validates the credentials. For data reduction you should have section application which applies filter on the data model. Section Appplication can have more than one field for data reduction.

Enclosed example on the same. You can open with userid: ADMIN and password: ADMIN

Kiran.

Re: Section access and data reduction

Thu, 03 Nov 2011 10:11:09 GMT

Thanks for your answer. I understand that section access authorizes the user and how to apply reduction on opening. What confuses me is what is the point of defining reduction values in the section access without checking "apply data reduction on opening". If it is not checked does it make any difference to define reduction values?

Also, once the document is opened, is there a way to know if there was a reduction?

Re: Section access and data reduction

Thu, 03 Nov 2011 14:08:30 GMT

Yes you are right, without selecting that option section application wont work. Only way I can see to find reduction is have a variable to store original record count in the script (so everytime script loads it saves the record count). In the document compute the record count and compare with teh variable.

Regards,

Kiran.

Re: Section access and data reduction

Thu, 03 Nov 2011 14:22:14 GMT

Thanks a lot for your insight!

So a qvw file which does not prompt for a password at opening and its "Initial data reduction based on section access" is uncheked in the document properties then every user will be able to open the file and everyone will get access to all the data?

(I am currently struggling with a problem of "not all users get the same data when opening the same document" on such a file....)

Re: Section access and data reduction

Thu, 03 Nov 2011 15:08:15 GMT

Geogre,

How is the authentication going for your document. What are the credentials you load thru Section Access? Also make sure that all your data as well as fieldnames in Access are in uppercase.

Regards,

Kiran.

Re: Section access and data reduction

Thu, 03 Nov 2011 15:24:24 GMT

There is no authentication (the document opens directly without prompting for an username or password), and the "Initial data reduction based on section access" is unchecked. However the customer tells me that some users do not have access to the whole document data. I suspected it had something to do with section access but it seems impossible without any prompt at document opening.

My question is: "is it possible to have a data reduction applied on the document opening if there is no prompt for the username or password?".

Re: Section access and data reduction

Thu, 03 Nov 2011 15:39:36 GMT

If there is no prompt how would the qvw know who logged in (only QVS has the information)? If you want to do it without prompt, below are the two ways which I use:

1) If you are using NTID authentication both for document access and section access the prompt is not asked when open and automatically data is reduced.

2) If you section access is custom then using query string you can pass the crenditals to open. An example of query string using ieplugin:

"http://localhost/QlikView/DocumentName.qvw?userid=<username>password=<password>"

Kiran

Re: Section access and data reduction

Thu, 03 Nov 2011 15:50:54 GMT

Sorry I forgot to say the document is accessed locally in the QlikView desktop application, and NOT from the network.

Let me sum-up my problem:

1) there is a qvw file which does not give access to the same data for all users opening it.

2) QlikView desktop does not prompt for anything when opening the document, and the document does not have the "initial data reduction" checked.

3) the section access part of the loading script is commented out

What can explain such a behavior? Is it possible that the document was not reloaded after commenting out the section access part of the script, and that section access is based on something like the windows user so that no prompt is required but the reduction occurs nonetheless?

Re: Section access and data reduction

Thu, 03 Nov 2011 15:59:02 GMT

Hmm, still thinking but meanwhile, to check out if the reload happened or not, check out the section application table columns and if its the data model. If its reloaded after commenting it might be filtered.

You can also see if the option "Remember login credentials until qlikview exits" is checked (Under userpreferences->General).

Kiran.

Re: Section access and data reduction

Thu, 03 Nov 2011 16:10:40 GMT

George,

Just trying out some possibilites, function qvuser() will return the logged in user (even for desktop application). If that one used in to set a filter using onopen trigger this is possible.

Kiran.

Section access and data reduction

Anonymous — Thu, 03 Nov 2011 16:28:45 GMT

Section Access has two functions:

1 - Authentication. Based on it, user can or cannot open the document. It may have login prompt (auth by user/password) or without prompt (e.g. by NTNAME).

2 - Data reduction. This is optional, and require reduction fields in Section Access and in Section Application, and the box must be checked.

There cannot be not data reduction if the box is not checked. There cannot be data reduction if Section Access doesn't exist (commented out)

Re: Section access and data reduction

Thu, 03 Nov 2011 16:37:28 GMT

@Michael: But if a document with a section access part in the loading script is reloaded and the section access part is commented out after the reload, will the section access still be active when someone opens the document after the file is saved?

Also, if someone opens a document with the "initial data reduction" checked, unchecks the box and save the document, will the document data of the saved contain all the initial data, just the data the user got when he opens or something else?

Re: Section access and data reduction

Thu, 03 Nov 2011 16:38:47 GMT

I just got a DSI from the customer, and it contains the line "Access USER" while I have a "Access ADMIN" when I open the same document. Doesn't it indicate that there is indeed a section access used in the document?

Section access and data reduction

Anonymous — Thu, 03 Nov 2011 16:41:50 GMT

Any changes in the script take effect only after reload.

Checkbox change doesn't require reload.

Re: Section access and data reduction

Thu, 03 Nov 2011 17:15:17 GMT

Kiran,

As I said the user who has the problem has a user access to the document and not an admin one, so there must be an active section access. I guess it is based on the windows user or the qv serial, so the access control can be done without prompt. It does not explain the data difference but it is a first step.

I have another question: how to know if there is an implemented section access in a document current data (because the script could have been modified and saved after the reload)?

Section access and data reduction

rrsrini2907 — Thu, 03 Nov 2011 17:21:30 GMT

The Section Access is applied in your document.

And FYI, the check box for "Initial Data Reduction Based on Section Access" will be effective when you open the document thtough web browser.

Even if there is no section access in ur document and when you check this option, open this document from Server.

It will prompt for username and password. If it is not through NTID.

Regards

Srini.

Section access and data reduction

Thu, 03 Nov 2011 17:22:35 GMT

Create an alert, On post reduce would help.

Kiran

Re: Section access and data reduction

Mon, 07 Nov 2011 10:36:22 GMT

I tried to call a macro called SayReduction on the OnPostReduceData event but it does not seem to be called for any user (tested on QV10 SR2).

I attached a test document which can be opened with the following credentials:

admin / admin -> admin access without data reduction
admin2 / admin2 -> admin access with data reduction
user / user -> user access with data reduction

Am I doing something wrong?