Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to implement security on Tab level. I searched the forum and found an exmple here http://community.qlik.com/thread/38348
Actually, this method works well. But the issue is I want to use excel sheet to reload the Control table, instead of INLINE load, since we have many records to maintain.After the application is reloaded and distributed through PUBLISHER, I can not open this application from Access Point. Here is the security code I used in this application.
It is urgent to solve this problem. I really appreciate your help.
1. With INLINE load, it works after Publisher
Section Access;
LOAD
ACCESS,
NTNAME
FROM
F:\...\Security.xls
(biff, embedded labels, table is Sheet4$);
Section Application;
Control :
LOAD * INLINE [
NTNAME, Tab
USER1, Y
USER2,
];
2. With excel sheet load, it failed to open a file after Publisher
Section Access;
LOAD
ACCESS,
NTNAME
FROM
F:\...\Security.xls
(biff, embedded labels, table is Sheet4$);
Section Application;
Control :
LOAD NTNAME,
Tab
FROM
F:\...\Security.xls
(biff, embedded labels, table is Sheet4$);
How to check the Publisher log?
In the QMC
Could you give me more detail how to check log from QMC? Thanks
Problem solved. Thanks, Jason
What was the problem?
one of the NTNAME caused the problem, not sure why now. After being removed, it works.
Strict Exclusion maybe? Anyway - glad you solved it. Please mark a correct answer to close the thread.
sure. BTW, could you tell me how to find publisher log? thanks
In the QMC, goto Status > Tasks, then expand the tree to find your job and click "Show Task Details" on the top right. Then select Log.
Hope this helps,
Jason
oh, I see. Thank you very much!