Please help
not able to open document with section access and sheet access after checking strict execution in document properties
includes code
SECTION Access;
User:
LOAD
UPPER(ID) as USERNAME,
UPPER(IPNAME) & '\' & Upper(ID) as NTNAME,
UPPER(ACCESS) as ACCESS,
UPPER(SALESGROUP) as SALESGROUPNP
FROM
[$(vFldrSources)\SecAccess.xls]
(biff, embedded labels, table is Sheet1$);
SECTION Application;
[Sheet Access]:
LOAD
UPPER(ID) as USERNAME,
UPPER(SHEETACCESS) as SHEETACCESS
FROM
[$(vFldrSources)\SecAccess.xls]
(biff, embedded labels, table is Sheet1$);
left Join
SheetAccess:
LOAD
UPPER(SHEETACCESS) as SHEETACCESS,
SH01,
SH04,
SH07,
SH08,
SH10,
SH11,
SH12,
SH13,
SH14,
SH18,
SH15,
SH16,
SH17,
SH19
FROM
[$(vFldrProjDataSources)\SHEET_Access_Master.xls]
(biff, embedded labels, table is Sheet1$)
Where not IsNull(SHEETACCESS);
Sales:
LOAD
%CustNum
UPPER(SALESGROUPNAME) as SALESGROUPNAME ,
USERNAME as ACCT_NUM
FROM
[$(vFldrProjWorkspace)\HHF.qvd] (qvd);
dont see any errors in my code and its working perfectly alright in my local server but throwing error once its published in accesspoint
