Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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

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 )

RELOAD ON MY NB.png

Can some one advise me where go wrong ?

Paul

21 Replies
rubenmarin

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/mana...

paulyeo11
Master
Master
Author

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

 

 

jonathandienst
Partner
Partner

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.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
paulyeo11
Master
Master
Author

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 ?
Arthur_Fong
Partner
Partner

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. 
 

paulyeo11
Master
Master
Author

Hi Arthur

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

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

paulyeo11
Master
Master
Author

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 ? 

remote pc os user.png

paulyeo11
Master
Master
Author

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