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,

I am little confused with your requirements.

You want to implement the session access on the basis of Qlikview Access Point Login Name

or User Machine Name.

If you want your section Acces on the basis of Qlikview Access Point Login Name

then I think it is working.

If you want your section Acces on the basis of User Machine Name.

then Section Access Will not work for you.

for that

You have to write on each sheet

if(wildmatch(ComputerName(),'MachineName',1,0)

Regards

[sarathi_pm]

Hi Max,

Thanks for the reply. I want the access restrictions on Access Point.

As per the current scenario, I have a text box with expression as NTNAME. When I login through desktop, it shows the correct NTNAME, whereas when I login through the Access Point, the textbox shows "Qlikview server Login ID" and not the user NTNAME who has logged on to Access Point.

[sarathi_pm]

yes. I have ADMIN and USER as the 2 values for the Access column.

[Bill_Britt]

Hi,

Can you either post you script and data here, or email it to me?

Bill

[PrashantSangle]

Hi,

Then it is working fine.

Just you have to do few changes in section Access Script.

In Your Section Access Script under NTNAME you have to mention "Qlikview Login Name" not machine NTNAME.

Regards

[sarathi_pm]

We have mentioned the Qlikview Service Login Name in the Section access script as ADMIN and tried both * as well as Blank for the Field Restrictions.

[sarathi_pm]

Please find the script below.

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

In one of the sheet where I want to hide/show based on the user logged in, In the conditional show of the sheet I have this expression

Sum(SHEET_ID)>=1

I have attached the user access file used in the script

[cesaraccardi]

Hi,

When you mentioned that it works fine when you open the application on the desktop, is it the same file that has been reloaded by publisher? Or in other words, have you got remote access to the server to check if the data reduction is working fine after the reloading?

Cesar

[#10]

I agree. you may need to check the way the application is deployed

[Bill_Britt]

Hi,

Take a look at the attached and the below script. This will do what you want. You will need to change the USERID to NTNAME and put your users there.

Section Access;

Security:

LOAD * INLINE [

    ACCESS, USERID, SHEET

    ADMIN,SERVICEACCOUNT,

    ADMIN, ADMIN, *

    USER, USER1, A

    USER, USER2, B

    USER, USER3, C

];

Section Application;

SheetAccess:

LOAD * INLINE [

    SHEET, SHEET1FLAG, SHEET2FLAG,SHEET3FLAG

    A, 1, 0, 0

    B, 1, 0, 1

    C, 1, 1, 1

];