I have this attached Section Access script and it doesn't work as I expect for CAKE user. CAKE has the access combined from DELL and ELEN users. DELL can see all products in UK and ELEN can see product "b" in any country. So I expect CAKE to see the data of any product in UK and all product "b" in any country. But what I got as a result is one unwanted record showing product "d" in DD country.
User and password for admin is admin.
Anyone who can help solving this is gonna be the hero or I am misunderstanding the way Section Access works, please let me know. Thank you so much in advance for any reply
The issue in ur case is just bec u assign * for all projects in an external table.. This is wrong...
I understand u use a seperate table to reduce data bec of all CAPITALISATION issue. but the way u have implemetned is wrong...
Data is reduced in the part bw Section access ...... and section application
...(data reduction happens here)
in the above described part as of the application that u haveve posted section access will look to select for "B" and "ALL PRODUCTS" in the field called procedure for ELEN... it will search for a string "ALL PRODUCTS" it will not return a * there. since ther is nothign in the name "ALL PRODUCTS", nothign will be selected. Change ur code accordingly , it should work...
Hope this helps..
thanks but your reply doesn't help, plus I got this example (PDF attached) from one of QlikTech consultants. I also sent them a mail asking the same question, hope they will reply soon. Once they do, I'll share it here too.
thanks again anyway
your logic is wrong:
and in the section application your defining it as
LOAD * INLINE [
ALL PRODUCTS, *
LOAD * INLINE [
ALL COUNTRIES, *
which mean finally the CAKE has all products and all country access.
its acting according to your input