Section Access Help

[#1]

Hi All,

I have section access implemented in the application for a particular sheet in the application. After reloading the application, correct data is displayed on the dashboard. But when I save and reopen the application again, the data displayed only on that particular tab is halved. Can someone please help me

[#2]

Can you please help me with the syntax. Where should I be writing NOREDUCTION?

[#3]

Would it work for multiple reducing fields?

[hic]

One way to do it is

Authorization:
Load
ACCESS,
NTNAME,
If(ACCESS='ADMIN', 'NOREDUCTION', REDUCTION) as REDUCTION
;
Load
Applymap('AdminUsers', Upper(NTNAME), 'USER') as ACCESS,
Upper(NTNAME) as NTNAME,
Upper(REDUCTION) as REDUCTION
From ... 

For multiple reducing fields, you should read Data Reduction Using Multiple Fields.

HIC

[#5]

In the statement If(ACCESS='ADMIN', 'NOREDUCTION', REDUCTION) as REDUCTION
is Reduction a field?

[#6]

Hi Henric,

I am using the below script in section access.

UserEntitlementFinal:
NOCONCATENATE LOAD
ACCESS
, NTNAME
, if(IsNull(AB) or Len(Trim(AB))>0,'',AB) as AB
, if(IsNull(CD) or Len(Trim(CD))>0,'',CD) as CD
,RESIDENT UserEntitlement;
DROP TABLE UserEntitlement;

AB and CD are reducing fields.

Data is displayed properly in this case. But when I open the document with USER, the document fails to open. When I uncheck Strict Exclusion, it works fine. Is it correct?

[hic]

"REDUCTION" is the field that you want to use as reducing field, yes.

You need to have Strict Exclusion on. If it doesn't open, then it means that there is no combination of AB and CD that the user has the right to see.

I would advice against using multiple reducing fields, of the reasons that I explain in Data Reduction Using Multiple Fields.

HIC