Section Access Works fine in desktop but not in Access Point

[sarathi_pm]

Hi Friends,

I have a qlikview application where I have implemented section access based on NTNAME. I have also included sheet level access based on the NTNAME .

When I open the qlikview application in the desktop, I am able to see the Sheets hiding correctly based on the user NTNAME. The NTNAME field shows the ID of the user who has logged in.

But when the same application is being reloaded using a publisher and when viewed through access point, the NTNAME shows the qlikview server login NTNAME and not the user NTNAME thereby not hiding the sheets as expected.

Some More info on my set up

1. I have enabled "Initial Data Reduction based on section access"

2. I have enabled "Strict Exclusion"

3. I have included the Qlikview service login as the Admin in the section access file with "*" for all the fields in the section Access

4. The data in the section access file is in UPPER case.

Section access script:

Section Access;
LOAD ACCESS,
UPPER(NTNAME) as NTNAME,
COUNTRY
FROM
[..\User_Access.xlsx]
(ooxml, embedded labels, table is [Access]);
Section Application;

User_Table:
LOAD
UPPER(NTNAME) as NTNAME,
SHEET_ID
FROM
[..\User_Access.xlsx]
(ooxml, embedded labels, table is [Sheet_Access]);

[PrashantSangle]

Hi,

use  OSUser()

Regards,

[sarathi_pm]

Could you please be little more elaborative? I am not understanding what to do with OSUSER(). Should I replace the NTNAME with OSUSER?

[#4]

OSUER() returns the logged in user. you are pulling the data credentials from a csv file right?

[#5]

mate,  I replied too early, I see what you are doing. I am looking.

[sarathi_pm]

Yes. I am pulling the section access data from a excel file.

Is it not NTNAME will capture the user name logged on to the Access point portal and OSUSER will capture the user logged on to the laptop/computer?

[#7]

How are you adding your script? is it through the Insert Access-->Section Access--> inline or ?

I can see that there is one column missing called ACCESS.

Can you try and for a test to insert your section access details through the above option. I am sure the Access column is missing here.

[Bill_Britt]

Hi,

The service account should not have a star(*) you want to leave it blank. If you have a star(*) you might not get all the data.

Bill

[#9]

ffffff sorry again I just noticed that you have it. ignore.

What values does the ACCESS column have . I assume either ADMIN or USER right?

[sarathi_pm]

Hi Bill.

Thanks for the reply. I tried that as well. But the issue is when I login through access point, the NTNAME is not showing the user id, instead it shows the qlikview service login id.