Section Access with Multiple Entries and Multiple Fields

[kanhomcake]

hi Community,

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

Best regards,

WV

[ashfaq_haseeb]

Hi,

Check this

http://community.qlik.com/docs/DOC-5973

http://community.qlik.com/docs/DOC-4435

http://community.qlik.com/docs/DOC-6331

http://community.qlik.com/docs/DOC-5917

Regards

ASHFAQ

[sundarakumar]

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

Secion access;

...

...(data reduction happens here)

...

Section application;

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..

-Sundar

[kanhomcake]

thanks but your links don't help, thanks again anyway

[kanhomcake]

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

[Anonymous]

did you resolved this,I also faced same issue

[hic]

You cannot use multiple reducing fields in Section Access. See Data Reduction Using Multiple Fields

HIC

[avinashelite]

your logic is wrong:

USER,	CAKE,	CAKE,		ALL PRODUCTS,	UK
USER,	CAKE,	CAKE,		B,				ALL COUNTRIES

and in the section application your defining it as

PLReduce:

LOAD * INLINE [

PLREDUCE, PRODUCTLINE

ADMINGROUP, *

A1, A1

ALL PRODUCTS, *

B, B

];

CountryReduce:

LOAD * INLINE [

COUNTRYREDUCE, COUNTRY

ADMINGROUP, *

UK, UK

ALL COUNTRIES, *

];

which mean finally the CAKE has all products and all country access.

its acting according to your input