Section Access: ? how to solve it

[qlikviewaf]

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

[YoussefBelloum]

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 ?

[qlikviewaf]

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?

[YoussefBelloum]

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

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

[qlikviewaf]

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

[YoussefBelloum]

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

[qlikviewaf]

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?

[qlikviewaf]

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

[PrashantSangle]

do you have data for Italy in application???

Uncheck strict exclusion > save > reload and then open.

[YoussefBelloum]

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