topic Sheet level access is not working after Distribution through Publisher in QlikView

Sheet level access is not working after Distribution through Publisher

nirav_bhimani — Mon, 06 Apr 2015 11:57:43 GMT

Dear Qv Expert,

I was trying to implement the sheet level access, its working fine If i do a manual reload but if I reload it through QMC (publisher) then it wont work, I have cross check the NT User credential in my Source Document & User Document file. In both the place its showing me different user. My problem is with the User Document, after distribution it always shows the local user credential data & sheet accordingly, no matter which credential you are using on access point.

Local user has a Admin Rights with all sheet access.

Script:

Section Access;

LOAD ACCESS,

UPPER(NTNAME) as NTNAME,

UPPER([SUB REGION]) as Region,

UPPER(TaskRegion) as TaskRegion,

UPPER(SHIPPINGCOUNTRY) as ShippingCountry

FROM

[..\Qvds\Users-QlikView_Dev.xlsx]

(ooxml, embedded labels, table is [SECTION ACCESS]);

Section Application;

LOAD Upper(NTNAME) as NTNAME,

SH36,

SH39,

SH09,

SH28,

SH19,

SH25,

SH26,

SH18,

SH06,

SH37,

SH38,

SH11,

SH35,

SH20,

SH31,

SH32

FROM

[..\Qvds\Users-QlikView_Dev.xlsx]

(ooxml, embedded labels, table is [SHEET ACCESS]);

Sheet Level Condition:

e.g. = IF(SUM(SH26)>=1,1,0)

Document Setting:

Initial data reduction based on section access is checked

Prohibit Binary reload is checked

Admin Override security is checked

I have cross check the below thread for the same but couldn't resolve this issue.

Thread:

Section Access does not work after publisher reload

Can any one help me to resolve this.

Thanks & Regards,

Nirav Bhimani

Re: Sheet level access is not working after Distribution through Publisher

mithilesh17 — Tue, 07 Apr 2015 07:35:28 GMT

Hi,

We are facing same issue like above. After distribution, section access is not working properly as it run on local...

Is it QEMC Bug?? or else please clarify if any one have faced same issue...

Thanks & Regards,

Mithilesh

Re: Sheet level access is not working after Distribution through Publisher

stabben23 — Tue, 07 Apr 2015 08:33:16 GMT

Hi,

I have the same problem, I solved it in my where statment like this:

......

FROM

[..\Qvds\Users-QlikView_Dev.xlsx]

(ooxml, embedded labels, table is [SHEET ACCESS])
where NTNAME <> "Your service account";

Re: Sheet level access is not working after Distribution through Publisher

stabben23 — Tue, 07 Apr 2015 09:43:28 GMT

Hi,

I have also unticked Strict Exclusion, if that helps.

Re: Sheet level access is not working after Distribution through Publisher

nirav_bhimani — Tue, 07 Apr 2015 10:14:20 GMT

Hi Staffan,

Thanks for a Quick response,

I did it other way, I have removed the local admin user from sheet access excel file.

Now its working fine.

Thanks & Regards,

Nirav Bhimani

Re: Sheet level access is not working after Distribution through Publisher

stabben23 — Tue, 07 Apr 2015 10:17:49 GMT

Hi,

Great, glad I can help.