Sheet level Section access issue with NTNAME works on Desktop but not in Access Point

[chaper]

I am trying to implement Sheet level section access based on NTNAME(upper case) as below.I have conditions  as if(Sheet1=1,1,0) and if(Sheet2=1,1,0) on both sheets.It works great in desktop.But when it is published to Server , I can see the application but if I try to open it say "failed to open or don't have to access".I don't know may be the NTNAME on AccessPoint in lower case compared to on desktop?Need help to fix this. swuehl‌ hic marcus_sommer

jagan‌   Thanks

Section Access;

LOAD ACCESS,

         NTNAME

FROM Table QlikSection Access;

Section application;

[Sheet Level]:

LOAD

     NTNAME,

     SHEET1,

     SHEET2;

FROM Table QlikSection Access;

[stabben23]

Hi,

if you are unsure about the ntmane add keyword Upper

Section Access;

LOAD ACCESS,

        upper(NTNAME ) as NTNAME

FROM Table QlikSection Access1;

Section application;

[Sheet Level]:

LOAD 

     upper(NTNAME) as NTNAME,

     Sheet1,

     Sheet2;

FROM Table QlikSection Access1;

You also need the service account added in the accesslist.

[chaper]

Thanks for reply .No luck even after using Upper.Still can't access app on AcceePoint

[marcus_sommer]

For testing disable the section access and use a textbox with: = osuser() to check that the osuser from the desktop client is the same as within the access point.

- Marcus

[chaper]

Thanks for reply.I did checked OSUser() on server without section access.It is in upper case and matches with NTNAME of my Section Access table.Service account is also in section access.As I am doing section access for sheets not data Do you think I am using right approach to show hide sheets?Do I have to pick selection based on Section Access option?

[marcus_sommer]

Is there any sheet within the application which is not included within the section access, for example SHEET3? For testings there should be at least one sheet without restrictions. Another try would be to use another browser - maybe the browser didn't transfer the osuser to the qlikview-server.

- Marcus

[chaper]

I added another sheet to show all the time.I did checked both IE and Chrome still getting same error as below.

Thanks

[Peter_Cammaert]

You're doing the right thing by enabling Data Reduction and checking the Strinct Exclusion checkbox. Otherwise it would never work.

If it works in QV Desktop, but doesn't work in the AccessPoint, you may be using an Admin account that hasn't got a single actual entry in table [Sheet Level]. Keep in mind that an ADMIN role will always grant you access to your document in QV Desktop (even with Strict Exclusion enabled) but will kick you out of your document in the AP because Admin doesn't exist in the AccessPoint.

Make a file copy of your document, open it in QV Desktop, change the SA table to list your account as a USER, enable Section Access, reload and save. Close QV Desktop. Now reopen your document in QV Desktop. Does it still work?

[krishnacbe]

Hi,

Can you Uncheck the "Strict Exclusion" check box and reload and publish to access point and check.

[stabben23]

If you change to this in Your sheet condition.

sum(if(upper(OSUser())=NTNAME,SHEET1))