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

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

Anonymous — Fri, 18 Sep 2015 10:57:40 GMT

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

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

lironbaram — Fri, 18 Sep 2015 17:51:16 GMT

you didn't added the code

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

sudeepkm — Fri, 18 Sep 2015 18:25:14 GMT

pls provide little bit more about your scenario.

are you using NTNAME - windows authentication or other.

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

Anonymous — Mon, 21 Sep 2015 10:31:18 GMT

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