Section access not working in access point after distribution

Wed, 24 May 2017 19:51:19 GMT

Hello All,

I implemented section access for multiple dimensions. I followed qlik view cook book logic. Users are able to open the QVW from QV Desktop and data reductions is also working fine. But when user try to open through access point, Access is denied. Even Admin can't open the file through Access point. Below is the sample code. Please provide your suggestion.

Thanks,
Rob

Product:

LOAD * INLINE [

ProductID, ProductGroup, ProductName

1, GroupA, Great As

2, GroupC, Super Cs

3, GroupC, Mega Cs

4, GroupB, Good Bs

5, GroupB, Busy Bs

];

Customer:

LOAD * INLINE [

CustomerID, CustomerName, Country

1, Gatsby Gang, USA

2, Charly Choc, USA

3, Donnie Drake, USA

4, London Lamps, UK

5, Shylock Homes, UK

];

Sales:

LOAD * INLINE [

CustomerID, ProductID, Sales

1, 2, 3536

1, 3, 4333

1, 5, 2123

2, 2, 4556

2, 4, 1223

2, 5, 6789

3, 2, 1323

3, 3, 3245

3, 4, 6789

4, 2, 2311

4, 3, 1333

5, 1, 7654

5, 2, 3455

5, 3, 6547

5, 4, 2854

5, 5, 9877

];

CountryLink:

Load Distinct

Country,

Upper(Country) As COUNTRY_LINK

Resident

Customer;

Load Distinct

Country,

'ALL' As COUNTRY_LINK

Resident

Customer;

ProductLink:

Load Distinct

ProductGroup,

Upper(ProductGroup) As PRODUCT_LINK

Resident

Product;

Load Distinct

ProductGroup,

'ALL' As PRODUCT_LINK

Resident

Product;

Section Access;

Access:

LOAD * INLINE [

ACCESS, USERID, PRODUCT_LINK, COUNTRY_LINK

ADMIN, ADMIN, *, *

USER, GM, ALL, ALL

USER, CM1, ALL, USA

USER, CM2, ALL, UK

USER, PM1, GROUPA, ALL

USER, PM2, GROUPB, ALL

USER, PM3, GROUPC, ALL

USER, SM1, GROUPB, UK

USER, SM2, GROUPA, USA

];

Section Application;

Re: Section access not working in access point after distribution

wendywallace — Wed, 24 May 2017 20:27:06 GMT

Does it work if you copy the Source Doc to the User Doc folder after reloading?

Re: Section access not working in access point after distribution

Thu, 25 May 2017 00:58:47 GMT

Yes I can open it through QV desktop

topic Section access not working in access point after distribution in QlikView

Section access not working in access point after distribution

Re: Section access not working in access point after distribution

Re: Section access not working in access point after distribution