topic Re: Section Access Creation in App Development

Section Access Creation

Lakshminarayanan_J — Thu, 03 Nov 2022 06:06:21 GMT

Dear All,

Need to create the section access based on Below template.

The Region, subregion, country, ProductGroup available in Fact table,

ACCESS

USERID

LDAP_Name

Type

Region

Subregion

Country

ProductGroup

@SwathiPulagam @vinieme12 @john_wang @rubenmarin @RafaelBarrios

Re: Section Access Creation

SunilChauhan — Thu, 03 Nov 2022 06:39:53 GMT

identify on which field you need to reduce Data. if it is Region then Section access would below

section Access;

Load ACCESS,UserID,Upper(Region) as Region Inline [

ACCESS,UserID,Region

Admin,User1 ,*

User,User2 ,East

User,User3 ,West

User,User4 ,North

User,User5,South

];

Section Application;

Load from source Table

Load

LDAP_Name,Type,Upper(Region) as Region,Subregion,Country,ProductGroup

From Path

Re: Section Access Creation

Lakshminarayanan_J — Thu, 03 Nov 2022 07:12:16 GMT

@SunilChauhan

Below are combination of data reduction, reduction will be based on any given column and it will have multiple value.

For Example: Region Will have America,EURO for one user like wise for all the column.

ACCESS	USERID	LDAP_Name	Type	Region	SubRegion	Country	ProductGroup	OMIT	Remarks
ADMIN	LN	LAK	Unrestricted
USER	SA	SAN	Restricted	Americas
USER	QA	AQA	Restricted		Latin America
USER	QA1	AQA	Restricted	Americas	Latin America
USER	QA1	AQA	Restricted			BE
USER	QA1	AQA	Restricted	Euro			OFR

Re: Section Access Creation

SunilChauhan — Thu, 03 Nov 2022 07:24:15 GMT

you can write

store above code in a Excel

section Access;

Load

ACCESS,USERID,LDAP_Name,Type,Region,SubRegion,Country,ProductGroup,OMIT,Remarks

From ExcelPath

Section Application;

Load your Source Data and Link with Section access Table

Re: Section Access Creation

Lakshminarayanan_J — Thu, 03 Nov 2022 07:32:18 GMT

@SunilChauhan

How can i link it with section access table , on basis of which field

Re: Section Access Creation

SunilChauhan — Thu, 03 Nov 2022 07:37:22 GMT

if reduction Field is Region then Link with Region

if Reduction firld is more than one then Use Composite Key ( combination of field)

section Access;

Load ACCESS,USERID,LDAP_Name&Type&Region&SubRegion&Country&ProductGroup as KeyReduction

,OMIT,Remarks

Load

ACCESS,USERID,LDAP_Name,Type,Region,SubRegion,Country,ProductGroup,OMIT,Remarks

From ExcelPath

Section Application;

Load your Source Data and Create same link key

LDAP_Name&Type&Region&SubRegion&Country&ProductGroup as KeyReduction in source table

Re: Section Access Creation

Lakshminarayanan_J — Thu, 03 Nov 2022 09:00:49 GMT

@SunilChauhan

It is working if have value in all the column , but when we have value in PRODUCT group and rest are empty , data are not displaying

Re: Section Access Creation

SunilChauhan — Thu, 03 Nov 2022 09:05:04 GMT

replace nonValue with Text BLANK