topic Re: Case 897 Why section access only work when reload on my note book ? in QlikView

Case 897 Why section access only work when reload on my note book ?

paulyeo11 — Mon, 22 Jun 2020 09:37:58 GMT

Hi All

I have below load script , it work fine when the script is reload on my note book OSUser = DESKTOP-9837GT0\pauly. When i implement this script on my Qlik View note book OSUser = QV-PC\QV , it will not work. because when i open the document , i only can view SOURCE = TS and not all SOURCE.

SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME, SOURCE
USER, DESKTOP-9837GT0\pauly,*
ADMIN, QV-PC\QV,TS

];

SECTION APPLICATION;

LOAD * INLINE [
SOURCE, description
TS, BECKHOFF
TA, SCADA
SD, MOTION
LE, ROBOTICS

];

Below image shown that when reload on my note book , i can view SOURCE = TS TA SD LE , When reload by another note book QV-PC\QV, when i open the QVW file , i only can view SOURCE = TS ( Which is not correct )

Can some one advise me where go wrong ?

Paul

Re: Case 897 Why section access only work when reload on my note book ?

rubenmarin — Mon, 22 Jun 2020 09:44:31 GMT

Hi, in section access you have

ADMIN, QV-PC\QV,TS

Which is telling to only access the source TS, change TS by * if you want to see them all.

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/manage-security-with-section-access.htm#anchor-2

Re: Case 897 Why section access only work when reload on my note book ?

paulyeo11 — Mon, 22 Jun 2020 09:54:02 GMT

Hi Sir

The below script , i only need this note book view SOURCE = TS , Which is correct.

ADMIN, QV-PC\QV,TS

My issue is when using this note book QV-PC\QV reload the script. and when i open i only can view SOURCE = TS

Below is the condition for my note book access right , i should be able to view all SOURCE.

DESKTOP-9837GT0\pauly,*

When the same script , using my note book to reload , i can view SOURCE = ALL

My issue is script must reload on my note book and send to user , it will work fine ,problem happen when script reload at QV-PC\QV notebook and when i open i can only view SOURCE = TS , Which is not correct.

Paul Yeo

Re: Case 897 Why section access only work when reload on my note book ?

jonathandienst — Mon, 22 Jun 2020 10:18:49 GMT

You should be able to reload without problems, providing the account has access to the data sources.

Section access / reduction is only applied when the document is opened. I plays no part during the reload of the document. So reloading using the QV-PC\QV account should not be a problem.

Re: Case 897 Why section access only work when reload on my note book ?

paulyeo11 — Mon, 22 Jun 2020 10:37:54 GMT

Hi Sir

Can you give me your OSUser , I add you to access all SOURCE , and reload the script using my notebook and I file attach , see you can view SOURCR = All ?

Re: Case 897 Why section access only work when reload on my note book ?

Arthur_Fong — Wed, 24 Jun 2020 02:58:12 GMT

Try to create a new admin which has the authority to view all:

SECTION ACCESS;
LOAD * INLINE [
ACCESS, NTNAME, SOURCE
USER, DESKTOP-9837GT0\pauly,*
ADMIN, QV-PC\QV,TS
ADMIN,QV-PC\QVAdmin,*
];

Reload your document with this new admin.

Re: Case 897 Why section access only work when reload on my note book ?

paulyeo11 — Wed, 24 Jun 2020 03:39:54 GMT

Hi Arthur

May I know OSUSER = QV-PC\QVAdmin is refer to your note book ?

Re: Case 897 Why section access only work when reload on my note book ?

Arthur_Fong — Wed, 24 Jun 2020 03:45:50 GMT

No, this is a new admin that you need to create for section access purpose.

Re: Case 897 Why section access only work when reload on my note book ?

paulyeo11 — Wed, 24 Jun 2020 03:53:22 GMT

Hi Sir

I just remotely log in to my Qlik view note book , and i capture the OSUSER as below . I don;t understand why you add a new new admin OSUSER = QV-PC\QVAdmin ?

Re: Case 897 Why section access only work when reload on my note book ?

paulyeo11 — Wed, 24 Jun 2020 04:08:00 GMT

Hi Sir

After i have add :-

ADMIN,QV-PC\QVAdmin,*

When i reload on QV-PC\QV Notebook , i open the QVW file , i see SOURCE = TS

and when i open on my note book DESKTOP-9837GT0\pauly , i see SOURCE = TS ( Which is wrong )

Any advise ?

Paul

Re: Case 897 Why section access only work when reload on my note book ?

Arthur_Fong — Wed, 24 Jun 2020 04:19:50 GMT

The point here is ADMIN need to have the full access to perform data reduction.

If you restrict ADMIN to view only TS, the rest of the user can only view TS Data.

Unless you specify ADMIN to view all.

Re: Case 897 Why section access only work when reload on my note book ?

Arthur_Fong — Wed, 24 Jun 2020 04:23:43 GMT

Either you specify the ADMIN to view all, or you add another ADMIN(eg: the service account used for installation) and provide it the authority to view all.

Re: Case 897 Why section access only work when reload on my note book ?

paulyeo11 — Wed, 24 Jun 2020 04:29:54 GMT

Hi Sir

Thank you very much . I just try to test and it work fine now.

Now my Question , how does Qlik View know which note book OSUSER is Admin ?

Paul Yeo

Re: Case 897 Why section access only work when reload on my note book ?

Arthur_Fong — Wed, 24 Jun 2020 04:32:55 GMT

The ID you logged into your PC will be the admin.

Re: Case 897 Why section access only work when reload on my note book ?

paulyeo11 — Wed, 24 Jun 2020 04:39:16 GMT

Hi Sir

Thank you very much , now i am clear . Just To sum up :-

For admin note book , i must create like below :-

ADMIN, QV-PC\QV,*

If i log into the above note book , and do reload and save the Doc , the above note book is admin.

So the rest of the note book , for example below right for my note book :-

USER, DESKTOP-9837GT0\pauly,TS
USER, DESKTOP-9837GT0\pauly,TA

Thank you once again.

Paul Yeo

Re: Case 897 Why section access only work when reload on my note book ?

paulyeo11 — Wed, 24 Jun 2020 05:23:07 GMT

Hi Sir

i have one related question , when i using below script , i can only view SOURCE=TS :-

ADMIN,DESKTOP-9837GT0\pauly,*

When i using below script , it work fine :-

ADMIN,DESKTOP-9837GT0\pauly,TS
ADMIN,DESKTOP-9837GT0\pauly,TA
ADMIN,DESKTOP-9837GT0\pauly,TP
ADMIN,DESKTOP-9837GT0\pauly,TI
ADMIN,DESKTOP-9837GT0\pauly,SD
ADMIN,DESKTOP-9837GT0\pauly,PM
ADMIN,DESKTOP-9837GT0\pauly,LE
ADMIN,DESKTOP-9837GT0\pauly,PW
ADMIN,DESKTOP-9837GT0\pauly,DA

Amy advise to me , why i cannot use "*" for view all SOURCE ?

Paul

Re: Case 897 Why section access only work when reload on my note book ?

Arthur_Fong — Wed, 24 Jun 2020 05:32:53 GMT

Taking this as example:

Example 1:
ADMIN, QV-PC\QV,*
USER, DESKTOP-9837GT0\pauly,TS

The * here refers to only TS, because * refers to 'All' in the resident table.
Since you have only TS in this table, * refers to only TS.

Example 2:
ADMIN, QV-PC\QV,*
USER, DESKTOP-9837GT0\pauly,TS
USER, DESKTOP-9837GT0\pauly,TA

Now the * refers to TS and TA.

Re: Case 897 Why section access only work when reload on my note book ?

paulyeo11 — Wed, 24 Jun 2020 05:45:00 GMT

Hi Sir

My question is refer to your example 2 below :-

USER, DESKTOP-9837GT0\pauly,TS
USER, DESKTOP-9837GT0\pauly,TA

Why i cannot replace by below :-

USER, DESKTOP-9837GT0\pauly,*

Any advise on this ? So that i don't need to write duplicate 9 line of script.

Paul Yeo

Re: Case 897 Why section access only work when reload on my note book ?

Arthur_Fong — Wed, 24 Jun 2020 05:51:12 GMT

No idea how to achieve this but i always create section access table in Excel.

So that i can drag and copy into new line.

Re: Case 897 Why section access only work when reload on my note book ?

paulyeo11 — Wed, 24 Jun 2020 05:53:27 GMT

Hi Sir

Okay i will try to use excel . Thank you for help me solve my headade.

Paul