Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 users
Ranu |
Chetan |
rberi |
I want to apply section access on the field level which is of name " Department " which has approx 290 codes.
Ranu wants to see 232 , 233 , 234, 235 ----- Departments
Rberi and chetan wants to see all 290 departments available .
Section access applied as followss ::::::
********************************************************************************************************
Load Upper(SHEETID) as SHEETID
FROM [..\Data\SectionAccess.xls] (biff, embedded labels, table is Sheet$);
Section Access;
Load upper([NTNAME]) as NTNAME,
upper([ACCESS]) as ACCESS,
'*' as SERIAL
FROM [..\Data\SectionAccess.xls] (biff, embedded labels, table is Access$);
concatenate
LOAD * INLINE [
ACCESS, NTNAME, SERIAL
ADMIN, *, Serial no
];
Join
LOAD
upper([NTNAME]) as NTNAME,
upper(DEPARTMENT) as [DEPARTMENT]
FROM [..\Data\SectionAccess.xls] (biff, embedded labels, table is Field$);
LOAD upper([NTNAME]) as NTNAME,
SHEETID
FROM [..\Data\SectionAccess.xls] (biff, embedded labels, table is Sheet$);
Section Application;
********************************************************************************************************
Attached is the section access which is used in code::::::
[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/7028.SectionAccess.xls:550:0]
NTNAME | DEPARTMENT |
Ranu | 232 |
ranu | 233 |
ranu | 234 |
ranu | 235 |
chetan | |
rberi |
NTNAME | ACCESS |
Ranu | Admin |
Chetan | Admin |
rberi | Admin |
NTNAME | SHEETID |
ranu | SH01 |
ranu | SH02 |
ranu | SH03 |
chetan | SH01 |
chetan | SH02 |
chetan | SH03 |
rberi | SH01 |
rberi | SH02 |
rberi | SH03 |
Please suggest what changes should i do in the section access code ot the excel file so that i can give rberi and chetan full access to 290 departments
Hi,
Use OMIT Command for restricting certain Owners and Leave blank for the owners to see all the departments
Regards
sunil
Hi sunil
Can you please alaborate and help me where should i do the changes exactly .. please...
I have to give this thing by the end of day to client
Hi Sir,
In section access if you use * then all the fields mentioned(included in section access) would be considered for the user. So if you use * here then only the four (132,233,234,235) departments would be available to the user. So what you have to do(i believe) add all the departments against those users in excel.
regards,
tresesco
Dear tresesco
this is not a good option , adding 100 users with 290 department is no appriciable ,...
please suggest some other way
Can Any body help me on this issueeeeee
PLzzzzzzzzzzzzzzzzzzzz
no body have solution
you dont have to keep an excel file with the combination of 290 departments and 100 users, but you must read into the section access the whole values of department, so the users who has * will have them all. you can read it with a load from the database. or you can put the section access area after you have loaded the departments table and then read into the section access from memory.
section access area can put any where in the script (except before a binary statement)
MAY BE THIS ONE IS HELPFUL 4 U ......
try like below
section access;
Load * inline [
access,userid,password,OMIT
user,ranu,ranu,department
user,Chetan,Chetan,DEP
user,rberi,rberi,DEP
];
SECTION Application;
tab1:
Load * inline [
department
232
233
234
235
236
237
];
load
if(department=232 or department=233 or department=234 or department=235,department) as DEP,
department
resident tab1;
drop table tab1;
in document properties-> opening tab-> check iniatial data reduction based on section access and uncheck strict exclution
hope this helps