Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
In my script
Section Access;
LOAD If(match(Upper(USER_ID), 'PARAJ'),'ADMIN', 'USER') As ACCESS,
Upper(USER_ID) As USERID,
'MYPW' AS PASSWORD,
ENTITY_ID & '-' & Text(LOB_ID) & '-' & Text(UBR_ID) & '-' & Text(SUB_UBR_ID) As SecurityKey;
SELECT DISTINCT U.USER_ID, P.LEGAL_ENTITY_ID, P. LOB_ID, P. UBR_ID, P.SUB_UBR_ID
FROM USER_ACCESS U,
REF_SUB_UBR P
WHERE U.ENTITY_ID = P.LEGAL_ENTITY_ID;
Section Application
;
And same SecurityKey I have in fact table
Records displayed perfect filtering in my case on my PC, but on others it display either mine data or all
I also have applied data reduction 1.
2. Dynamic update
Why data do not pop up based on access, any idea please?
I need to restrict data as per user's access given
I appreciate your help
Thanks
I cannot say that this info is enough, but for successful data reduction the SecurityKey should be renamed to SECURITYKEY, and the upper() function should be used:
upper(ENTITY_ID & '-' & Text(LOB_ID) & '-' & Text(UBR_ID) & '-' & Text(SUB_UBR_ID)) As SECURITYKEY
That is, the reduction field name and field data must be in all capital - both in section access and section application.
correct