Section Access Is Not Working Based on Period

dineshm030 — Fri, 15 Nov 2024 20:52:57 GMT

Hi All,

I have created the section access with the below script.

AuthBridge:

Load Upper(BusinessUnit) & Upper(Team_Level_1) & Upper(RegionDesc) & Upper(AMHQCode) & Upper(SAP_TerritoryDesc) as AuthID,
Upper(BusinessUnit) & Upper(Team_Level_1) & Upper(RegionDesc) & Upper(AMHQCode) & Upper(SAP_TerritoryDesc) as %AuthID
Resident Fact_Sales;

Load Upper(BusinessUnit) & Upper(Team_Level_1) & Upper(RegionDesc) & Upper(AMHQCode) & Upper(SAP_TerritoryDesc) as AuthID,
Upper(BusinessUnit) & Upper(Team_Level_1) & '*' & Upper(AMHQCode) & Upper(SAP_TerritoryDesc) as %AuthID
Resident Fact_Sales;

Load Upper(BusinessUnit) & Upper(Team_Level_1) & Upper(RegionDesc) & Upper(AMHQCode) & Upper(SAP_TerritoryDesc) as AuthID,
Upper(BusinessUnit) & Upper(Team_Level_1) & Upper(RegionDesc) & '*' & Upper(SAP_TerritoryDesc) as %AuthID
Resident Fact_Sales;

Load Upper(BusinessUnit) & Upper(Team_Level_1) & Upper(RegionDesc) & Upper(AMHQCode) & Upper(SAP_TerritoryDesc) as AuthID,
Upper(BusinessUnit) & Upper(Team_Level_1) & '*' & '*' & Upper(SAP_TerritoryDesc) as %AuthID
Resident Fact_Sales;

Load Upper(BusinessUnit) & Upper(Team_Level_1) & Upper(RegionDesc) & Upper(AMHQCode) & Upper(SAP_TerritoryDesc) as AuthID,
Upper(BusinessUnit) & '*' & '*' & '*' & '*' as %AuthID
Resident Fact_Sales;

Load Upper(BusinessUnit) & Upper(Team_Level_1) & Upper(RegionDesc) & Upper(AMHQCode) & Upper(SAP_TerritoryDesc) as AuthID,
Upper(BusinessUnit) & '*' & Upper(RegionDesc) & '*' & '*' as %AuthID
Resident Fact_Sales;

Some sales have been moved manually in the backend script to Supra region for Q3. The security file is linking by AUTHORISATIONKEY with this AuthBridge table.

The section access is functioning correctly according to our security file, but it doesn't operate as expected with time periods when manual backend changes are made.

When selecting Jun, the section access is working fine whereas in July supra data also visible.

Please help on this.

Thanks in advance.

Re: Section Access Is Not Working Based on Period

marksouzacosta — Wed, 28 Aug 2024 17:06:35 GMT

Hi @dineshm030,

I don't think this will solve your problem (maybe!), but it is a common and good practice to add a separator when combining strings. Please consider doing the following, it can save you a lot of headaches:

Load 
Upper(BusinessUnit) & '|' & Upper(Team_Level_1) & '|' & Upper(RegionDesc) & '|' & Upper(AMHQCode) & '|' & Upper(SAP_TerritoryDesc) as AuthID,
Upper(BusinessUnit) & '|' & Upper(Team_Level_1) & '|' & Upper(RegionDesc) & '|' & Upper(AMHQCode) & '|' & Upper(SAP_TerritoryDesc) as %AuthID
Resident Fact_Sales;

This will avoid any unwanted and unaware combination that sometimes can be really hard to catch.

Regards,

Mark Costa

Re: Section Access Is Not Working Based on Period

dineshm030 — Thu, 29 Aug 2024 06:29:31 GMT

Hi @marksouzacosta

Thanks for your response. We need remove the access SUPRA region for Q3.

topic Re: Section Access Is Not Working Based on Period in App Development

Section Access Is Not Working Based on Period

Re: Section Access Is Not Working Based on Period

Re: Section Access Is Not Working Based on Period