Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
sarathi_pm
New Contributor II

Section Access Works fine in desktop but not in Access Point

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]);

1 Solution

Accepted Solutions
cesaraccardi
Valued Contributor

Re: Section Access Works fine in desktop but not in Access Point

I think this might help you: Re: Issue in Using NTNAME in Section Access and reloading the application using Publisher.

It looks like the QlikView Service Login Name must be listed on the section access but not in the section application.

21 Replies

Re: Section Access Works fine in desktop but not in Access Point

Hi,

use  OSUser()

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
sarathi_pm
New Contributor II

Re: Section Access Works fine in desktop but not in Access Point

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

Not applicable

Re: Section Access Works fine in desktop but not in Access Point

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

Not applicable

Re: Section Access Works fine in desktop but not in Access Point

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

sarathi_pm
New Contributor II

Re: Section Access Works fine in desktop but not in Access Point

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?

Not applicable

Re: Section Access Works fine in desktop but not in Access Point

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.

Employee
Employee

Re: Section Access Works fine in desktop but not in Access Point

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

Not applicable

Re: Section Access Works fine in desktop but not in Access Point

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
New Contributor II

Re: Section Access Works fine in desktop but not in Access Point

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.

Community Browser