Section Access Creation

[Lakshminarayanan_J]

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 

#

[SunilChauhan]

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

[Lakshminarayanan_J]

@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

[SunilChauhan]

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

[Lakshminarayanan_J]

@SunilChauhan 

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

[SunilChauhan]

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

[Lakshminarayanan_J]

@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 

[SunilChauhan]

replace  nonValue with Text BLANK