topic Re: Object or sheet level section access in QlikView

Object or sheet level section access

raju_salmon — Wed, 15 Feb 2017 09:23:57 GMT

Hi,

I have implemented section access using below thresds and it is working fine while using USERID.

https://community.qlik.com/docs/DOC-4435

https://community.qlik.com/docs/DOC-7327

However if we use NTNAME and approach the same, it is showing error while opening from access point that "Failed to open document. You do not have access"

Even i have found many comment in thread Chart Level Access by user saying that NTNAME is not working for them. But i have not found any solution.

Can anyone help why this approach not working when it comes to NTNAME?

Re: Object or sheet level section access

raju_salmon — Wed, 15 Feb 2017 09:32:20 GMT

I mean NTName is working with desktop, but not from access point.

Re: Object or sheet level section access

vardhancse — Wed, 15 Feb 2017 09:33:57 GMT

Hi,

NTNAME base section access have some condition:

1. System login matches it will open directly

2. If if falls under different domain, it will prompt for ID and password.

Check the system domain as well.

Because in access point the NTNAME will be based on domain.

Re: Object or sheet level section access

sasikanth — Wed, 15 Feb 2017 09:35:36 GMT

Have you tried with NTNAME in you desktop ?, are you able to login ?

Make sure NTNAME should be like: Domain\username.

if not please share your section access script.

Re: Object or sheet level section access

raju_salmon — Wed, 15 Feb 2017 09:52:33 GMT

Using Same.

Domain\username.

Domain\RAJU_S

For me it is working in desktop, but not through access point.

Section Access;

SA:

LOAD ACCESS,

Trim(UPPER(NTNAME)) AS NTNAME,

Trim(UPPER(STORE)) AS STORE

FROM

[..\Data\Section..xlsx]

(ooxml, embedded labels, table is sheet1);

Section Application;

//It is working if i comment below section.// working for only filter store data, not to hide sheets.

SectionAccess:

LOAD

Trim(UPPER(NTNAME)) AS NTNAME,

Sheet2,

Sheet3

FROM

[..\Data\Section.xlsx]

(ooxml, embedded labels, table is sheet1);

Re: Object or sheet level section access

sasikanth — Wed, 15 Feb 2017 10:04:58 GMT

Section Access;

SA:

LOAD ACCESS,

Trim(UPPER(NTNAME)) AS NTNAME,

Trim(UPPER(STORE)) AS STORE

FROM

[..\Data\Section..xlsx]

(ooxml, embedded labels, table is sheet1);

Section Application;

//It is working if i comment below section.// working for only filter store data, not to hide sheets.

SectionAccess: ( Remove this)

LOAD

Trim(UPPER(NTNAME)) AS NTNAME,

Sheet2,

Sheet3

FROM

[..\Data\Section.xlsx]

(ooxml, embedded labels, table is sheet1);

Re: Object or sheet level section access

raju_salmon — Wed, 15 Feb 2017 10:29:17 GMT

Same issue Sasi.

Re: Object or sheet level section access

sasikanth — Wed, 15 Feb 2017 11:18:23 GMT

Would you be able to share your application?

Re: Object or sheet level section access

vardhancse — Wed, 15 Feb 2017 11:22:27 GMT

SECTION ACCESS;

Access:

LOAD

ACCESS,

NTNAME

FROM

[Section_Access.xlsx]

(ooxml, embedded labels, table is Access);

SECTION Application;

star is *;

Security:

LOAD NTNAME,

DEPARTMENT

FROM

[Section_Access.xlsx]

(ooxml, embedded labels, table is Security);

In QMC try to enable below option: