Section Access using multiple dimensions

Wed, 25 Nov 2020 16:16:04 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;

topic Section Access using multiple dimensions in QlikView

Section Access using multiple dimensions