Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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..

3 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

you didn't added the code

sudeepkm
Specialist III
Specialist III

pls provide little bit more about your scenario.

are you using NTNAME - windows authentication or other.

Anonymous
Not applicable
Author

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