Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying section access in Qliksense. I have list of userid and I want to give Profit Center wise section access
ex.
Query1:
Userid, profit center
A,All Profit center
B,123
C,234
I want user A to see all the Profit Center available but it is showing only 123 & 234.
I tried keeping profit center blank, by putting *. But it not working
Query2:
Userid,Plant,Profit Center
A,2011,123
B,2012,234
B,2012,456
C,All plant, All Profit Center
Here I want to give data level section access like user A have access to plant 2011 and Profit center 123 and User C have access to all plant and all profit center then how can I achieve this??
Help!!
Make sure that everything you write under Section access script is in UpperCase
Section Access;
Load * Inline [
ACCESS , USERID, "PROFIT CENTER"
ADMIN, A,
USER,B,123
USER,C,234
];
Section Application;
Yes I wrote in Upper case,section access and application.
how Profit Center field is written as in Data Model?
"Profit Center" or "PROFIT CENTER"?
You will have to have Field name as "PROFIT CENTER" in Data Model as well
Star is *;
/////////////////////////////////////////////
Section access;
LOAD * inline [
ACCESS, USERID,PROFIT CENTER
USER, INTERNAL\SA_SCHEDULER, *
USER, ABCDomain\UserA, *
USER, ABCDomain\UserB, 123
USER, ABCDomain\UserC, 234
];
Section Application;
/////////////////////////////////////////////
Not sure about your 2nd SA query....
It is contradicting 1st query. User A has full access to Profit Center and then in 2nd query you are giving access to only 123 Profit Center.
To give the user access by NT name either check their Domain in Active Directory or use =OSUSERS() in text box for correct NT Name and use that name instead of ABCDomain\USER...
Internal Scheduler is an Admin account in QMC, used to reload the apps doesn't hurt to have it in script.
And if you get locked out of your app then right click on the app>'Open without Data'
That would open the script to modify the script.