topic Re: Section Access: ? how to solve it in QlikView

Section Access: ? how to solve it

qlikviewaf — Tue, 13 Feb 2018 15:35:11 GMT

Hi,

i just implemented Section access as follow

SECTION ACCESS;

LOAD * INLINE [

ACCESS, NTNAME, REGION_DESCRIPTION

USER, EMEA\AZARRA, ITALY

];

the NTNAME is the one coming out from Upper(OSUser()) formula.

Then i flagged the 2 checkbox here.

when i enter the application i'm able to see everything.

There's some step that i'm missing?

Thank you

Re: Section Access: ? how to solve it

YoussefBelloum — Tue, 13 Feb 2018 15:38:42 GMT

Hi,

you're working on Qlikview Desktop or entreprise ?

if you are testing on the desktop:

when you checked the "Strict exclusion" option, did you reloaded the app, saved and re-open it ?

Re: Section Access: ? how to solve it

qlikviewaf — Tue, 13 Feb 2018 15:43:57 GMT

i just reloaded the app, saved it, and moved to the server-folder to be available on the accesspoint.

i'm using Qlikview Desktop.

Any idea?

Re: Section Access: ? how to solve it

YoussefBelloum — Tue, 13 Feb 2018 15:57:16 GMT

I just realized that you put osuser() instead of writing the NTNAME.

if the server read osuser() what will it find ?

Re: Section Access: ? how to solve it

qlikviewaf — Tue, 13 Feb 2018 15:59:28 GMT

i wrote NTNAME - with formula osuser() i got exactly EMEA\AZARRA

Re: Section Access: ? how to solve it

YoussefBelloum — Tue, 13 Feb 2018 16:04:03 GMT

yes because on the desktop it will read YOUR NTNAME via the OSUSER() function.

but on the server it can't read OSUSER() of all the users on which you want to apply data reduction

Re: Section Access: ? how to solve it

qlikviewaf — Tue, 13 Feb 2018 16:06:09 GMT

Yes but as you can see from my script i used NTNAME

SECTION ACCESS;

LOAD * INLINE [

ACCESS, NTNAME, REGION_DESCRIPTION

USER, EMEA\AZARRA, ITALY

];

so what can i check?

Re: Section Access: ? how to solve it

qlikviewaf — Tue, 13 Feb 2018 16:08:48 GMT

btw using Upper(OSUser()) also on access-point i got the same result

Re: Section Access: ? how to solve it

PrashantSangle — Tue, 13 Feb 2018 16:12:29 GMT

do you have data for Italy in application???

Uncheck strict exclusion > save > reload and then open.

Re: Section Access: ? how to solve it

YoussefBelloum — Tue, 13 Feb 2018 16:12:35 GMT

it is a bit confusing because you talk about the OSUSER() function on the server and at the same time you wrote NTNAME on a load inline..

if you put this at the of your script:

Section access;

SECTION ACCESS;

LOAD * INLINE [

ACCESS, NTNAME, REGION_DESCRIPTION

USER, EMEA\AZARRA, ITALY

];

Section Application;

you will see that this user will be reduced to that area.

now, if you use osuser() on your section access table, it will not work

Re: Section Access: ? how to solve it

YoussefBelloum — Tue, 13 Feb 2018 16:15:03 GMT

there is something wrong because with strict exclusion if there is no Italy data, he will see a restriction message..

I'm I wrong ?

Re: Section Access: ? how to solve it

qlikviewaf — Tue, 13 Feb 2018 16:15:45 GMT

i just used osuser() to check if domain\user was correct: i'm not using this on the section access.

Of course i have data from italy, in the field "Region_Description" with value "Italy"

Re: Section Access: ? how to solve it

qlikviewaf — Tue, 13 Feb 2018 16:17:27 GMT

Re: Section Access: ? how to solve it

YoussefBelloum — Tue, 13 Feb 2018 16:17:58 GMT

do you wrote Section access; and Section Application; like mentioned above ?

Re: Section Access: ? how to solve it

qlikviewaf — Tue, 13 Feb 2018 16:22:23 GMT

This is exactly what i have on my script

Re: Section Access: ? how to solve it

PrashantSangle — Tue, 13 Feb 2018 16:40:32 GMT

If there is no Italy data then user will see all data.

Re: Section Access: ? how to solve it

PrashantSangle — Tue, 13 Feb 2018 16:41:35 GMT

Section access is case sensitive

Italy should be in caps

Re: Section Access: ? how to solve it

PrashantSangle — Tue, 13 Feb 2018 16:43:38 GMT

Screen shot which you post earlier and above posted data wont match..

here REGION_DESCRIPTION is caps and Value ITALY in caps but

earlier screen shot both are in small letter.

Is there anything which we are missing\??

Re: Section Access: ? how to solve it

YoussefBelloum — Tue, 13 Feb 2018 16:43:46 GMT

If there is no Italy data and there is user who is reduced to Italy, what is the difference between Strict exclusion SA and NOT strict exclusion SA as a result for that user then ?

Re: Section Access: ? how to solve it

qlikviewaf — Tue, 13 Feb 2018 16:45:33 GMT

Good point - in the data-set the value is "Italy" - is something manageable?

What i have to write then in the Section Access? "Italy" as well? or it's required to have only CAPS value?