Section Access using multiple dimensions

[#1]

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;