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;
