Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Do you face the problem only in access point?
Yes Krishnapriya, i tried using different browsers and faced same error ?
you are able to open the file in QV desktop?
Yes
does your Browser is enabled with SSO? if so verify whether the NTNAME is same as you defined in Section access part.
UPPER(IPNAME) & '\' & Upper(ID) as NTNAME
I am not so experienced about sso
but these are my settings in attachment do you think need to be changed
Ok. Try this command =OSUser() in any QVW file that is the NTNAME. Please check whether your section access NTNAME and this matches.
Hopefully check whether you need to add your domain name + User ID as NTNAME.
In top right corner of your access point you can find the NTNAME.
YES They matched accept in section access it is capital letters
eg: section access: it is CISCO/DSEELAM
QVW: CISCO/dseelam
Accesspoint : CISCO/dseelam
think it doesn't matter