topic section access does not work in reduction cases in QlikView

section access does not work in reduction cases

Masi_Sahargahi — Tue, 24 Nov 2015 06:49:06 GMT

Hi everybody

I have a problem with section access while reduction

Actually I have an excel file and its structure is like that:

SECTION ACCESS;
LOAD ACCESS,
NTNAME,
[Id Branch]
FROM
[*****\PermissionFile.xlsx]
(ooxml, embedded labels, table is Sheet1);
Section Application;

And it contains AD users and groups who are supposed to see documents. The reload task runs successful but the problem is that every user whom I added to the file and is supposed to just see his related branch, see all the files (for all branched).

It gets me on a big problem, do you have any suggestion to help me out of this?

Re: section access does not work in reduction cases

michael123 — Tue, 24 Nov 2015 09:14:21 GMT

First: Use capital letters for section access. Second: Check "Reduce data according to section access" (or similar) under Settings-> Document settings -> Opening.

/Michael

Re: section access does not work in reduction cases

maxgro — Tue, 24 Nov 2015 09:21:40 GMT

Use upper for field name and values in section access; more detail in the Qlik help, look for Security

Also, from Qlik Help:

In order for this procedure to take place, the option Initial Data Reduction Based on Section Access on the Document Properties: Opening page must be selected

Make a backup of your working .qvw before adding section access

Re: section access does not work in reduction cases

NareshGuntur — Tue, 24 Nov 2015 09:23:08 GMT

Document Properties --> Opening tab

"Initial Data reduction based on Section Access" and "Strict Exclusion" should be checked.

This will be unchecked by default.

Cheers,

Naresh

Re: section access does not work in reduction cases

Mark_Little — Tue, 24 Nov 2015 09:27:21 GMT

Hi,

As people have mentioned above.

First check the your excel document.

NTNAME, should be upper and have the domain like DOMAIN\USERNAME.

Then in the document itself

Settings > Document Properties > Opening tab

Initial Data reduction based on Section Access needs to be ticked.

Mark