Section Access

[ritumishra01]

UserData:
LOAD "USER_ID" as SurgLogOPID,
NAME,
"PROV_ID",
"EPIC_EMP_ID",
;
SQL SELECT "USER_ID",
NAME,
"PROV_ID",
"EPIC_EMP_ID"
FROM clarity.dbo."CLARITY_EMP"
;

SurgSup:
LOAD Distinct
SurgCardItemKey,
HAR,
UnknownPanelMarker,
Surgeon AS SURGEON,
SurgLogOPID,
SurgeonID, //prov_id
OrProcedure,
all_proc_as_ordered,
ItemMfg,
ItemType,
SurgeryDate,
AmtUsed,
AmtWasted,
CostPerUnit,
AmtUsed * CostPerUnit as TotCost,
SurgLocation,
SurgFacility,
SurgInRoomDT,
SurgOutRoomDT,
Date#(Interval((SurgOutRoomDT) - (SurgInRoomDT),'m')) as ProcLength,
Interval((SurgOutRoomDT) - (SurgInRoomDT),'m') as zzzProcInterval,
SurgicalService
resident surgload;
//where ApplyMap('UserAccessMap' ,SurgLogOPID,0);
drop tables surgload, surgtransform;

Section Access;
Section_Access:
load
'USER' as ACCESS ,
'DS/'&SurgLogOPID as USERID,
SURGEON as OMIT
Resident SurgSup;

Section Application;
exit script;

Can anyone tell wht is the error in code as i am still seeing Surgeon values. its not working as expected .

[TcnCunha_M]

Kind of work as expected , because there nothing to be filter.

in order to reduce the data an proper way you need to have a field on the table where Qlik can  connect between your session access table and data model , so let's  just say add a new field and make SurgLogOPID AS  USERID it will be reducing the data base by ID and will probably will Omit the data 😄

[ali_hijazi]

under the field OMIT the value has to be SURGEON
you want not to see the field SURGEON at all in the app? or you want to filter in some values of the SURGEON column?
currently you are putting the values of the SURGEON column under OMIT
you need to put (I assume) 'SURGEON' as OMIT

[ritumishra01]

Hi , Thanks for your response , i am looking out for something where surgeons who logs in to app should not be able to see other surgeon names ,they should be able to see only their names.

[TcnCunha_M]

IN that case you don't need OMIT, OMIT will hide the field , Session access if work correctly should not allow you to see other data with is not assign to you