Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have created an application with section access and linked it with the below script.
Section Access;
LOAD ACCESS,
NTNAME,
NAME,
Upper(BU) as BUSINESS,
Upper(REGION) as REGION,
Upper(AREA) as AREA
FROM $(vCONFIG)Section Access.xlsx
(ooxml, embedded labels, table is [Section Access]);
Section Application;
BUSINESS:
LOAD BusinessUnit,
RegionDesc,
AMHQCode,
Upper(BusinessUnit) AS BUSINESS,
Upper(RegionDesc) as REGION,
Upper(AMHQCode) as AREA
Resident
Dim_BusinessArea;
Enclosed is the Excel which I am using for the section access.
Hi,
that's because the initial reduction of section access.
You need to make sure that every value for BU,REGION and AREA exists in the section access table, otherwise they wont appear in your report after opening it.
This happens when you use the * wildcard.
Please let me know if this helps.
Kind regards,