Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me on below issue.
I am working on Section access for data level security.
I have created section access Excel file like below
Excel Source:
USERID,ACCESS,ID
SF/ERG,ADMIN,*
SF/UKJ,USER,4856A
Script:
Section Access;
Load
Upper(USERID) as USERID,
Upper(ACCESS) as ACCESS,
Upper(ID) as ID
From ….
Section Application;
Employee:
Load
Upper(ID) as ID,
Name,
Department,
Branch
From.....
But when I login with the SF/ERG ADMIN account I am able to see only 4856A ID in ID Field which is assigned to the user.
But as an admin I need to see all the ids in ID Field.
Please let me know am I missed any thing
Thanks in advance.
The Star (*)in the Section Access means not all the data but the values mentioned in the Section Access only.
May be this will help:-
Section Access. All users with exception of some
i suggest you to take a look at working with SA in Qliksense qmc
there you'll find the script needed to achieve it.
I hope it can help.
Hi agigliotti,
Thanks for your reply.
I have gone through the thread. Could you please check the below code once for my scenario.
Please let me know am I need to make any changes in this script and please let me know do we need to make any changes in QMC to implement the below script.
I am looking for the script which is directly working in the app without making any changes in QMC.
SECTION ACCESS;
TEST:
LOAD *
INLINE [
ACCESS, USERID, ID
ADMIN, SF/ERG, ALLVALUES
USER, SF/UKJ, 4856A
];
SECTION APPLICATION;
STAR IS '*';
tab1:
load
ID,
ID as SEC_ID
resident TEST where ID<> 'ALLVALUES';
concatenate
load
ID,
'*' as SEC_ID
resident TEST where ID = 'ALLVALUES';
Excelsource:
Load
ID,
Name,
Department,
Branch
From lib://Excel.qvd..
Thanks in advance
I can't see the field SEC_ID in your Excelsource table.
Thus it can't works.
Hi Mahitha,
You should not fill anything in for the Admin.
When you use a wildcard, only the rows that are filled in will be shown to the employee!
If you add a non existing value or blank value it will show all values for an Admin.
If you do this for a user, the access is denied.
Regards,
Jordy - Climber