Section Access with Multiple fields its working on desktop not access point

[Anonymous]

Hi All,

I want to give Section Access with Multiple fields its working on desktop ,same qvw published to the access point using QMC(Reload and distribute) not working .I am getting the error failed to open the document,you don't have permission.

Please find the code in attachment.

Thanks in advance..

[lironbaram]

hi

you didn't added the code

[sudeepkm]

pls provide little bit more about your scenario.

are you using NTNAME - windows authentication or other.

[Anonymous]

Section Access;

LOAD UPPER(ACCESS) as ACCESS,

UPPER(NTNAME) as NTNAME,

UPPER(Domain) as NTDOMAIN,

REPORTING_OFFICE &'|'& LOCAL_BRANCH_ANALAYSIS_CODE as %AuthID

FROM

(ooxml, embedded labels, table is Users);

Section Application;

-----------------

//Bridge Table used for Section Access

Bridge:

     Load [Rep-OffOO] &'|'& [Loc-Br-AnalOO] as AuthID, [Rep-OffOO] &'|'& [Loc-Br-AnalOO] as %AuthID  From $(HF_OGIS_QVD)(qvd);

     Load [Rep-OffOO] &'|'& [Loc-Br-AnalOO] as AuthID, [Rep-OffOO] &'|'&'<ANY>' as %AuthID  From $(HF_OGIS_QVD)(qvd);

     Load [Rep-OffOO] &'|'& [Loc-Br-AnalOO] as AuthID, '<ANY>'&'|'& [Loc-Br-AnalOO] as %AuthID  From $(HF_OGIS_QVD)(qvd);

     Load [Rep-OffOO] &'|'& [Loc-Br-AnalOO] as AuthID, '<ANY>'&'|'&'<ANY>' as %AuthID  From $(HF_OGIS_QVD)(qvd);

---

LOAD [Rep-OffOO] as [Reporting/Issuing Office],

     [Rep-OffOO] &'|'& [Loc-Br-AnalOO] as AuthID,

     [Cur-CdOO] as [Currency Code],

     [OrgOO] as [Organization Code],

     [Mgr-CdOO] as [Manager Code],

     [Maj-LinOO] as [Major Line],

     [Min-LinOO] as [Minor Line],

     RowNo() as RowNumber

FROM

QVD

(qvd);

-------------

OGIS_DATA_Users1.xlsx- data

ACCESS NTNAME     REPORTING_OFFICE LOCAL_BRANCH_ANALAYSIS_CODE DOMAIN

ADMIN       R1-CORE\ADMIN <ANY>        <ANY>   R1-CORE

USER       R1-CORE\abc <ANY>         NA R1-CORE