topic Re: Section Access problem in QlikView

Section Access problem

giakoum — Fri, 11 Jan 2013 09:45:51 GMT

Hi all.

I have posted the same issue before, but have not solved it yet.

I need user 2 (password: 1) to access ONLY the following :

BU1, EUROPE, NW EUROPE, 1

BU1, EUROPE, S EUROPE, 2

BU2, EUROPE, NW EUROPE, 11

instead, he can access the following record as well :

BU2, EUROPE, S EUROPE, 12

This is because for BU1 he has already access to both NW EUROPE & S EUROPE, so he gets it for BU2 as well.

Is there a workaround here?

ADMIN username : 1

ADMIN password : 1

See attached file.

Thank you

Ioannis

Re: Section Access problem

rajni_batra — Fri, 11 Jan 2013 10:42:24 GMT

PFA

Re: Section Access problem

giakoum — Fri, 11 Jan 2013 10:50:58 GMT

Thank you rajni, but you have included value in the section access, which is not possible. Value is a fact, not a dimension, we cannot exclude records based on that. It changes in every reload.

Re: Section Access problem

flipside — Fri, 11 Jan 2013 11:19:03 GMT

Hi Ioannis,

Your security isn't granular enough, you need to factor in the combination of PF and AREA and add that to the security table. One way is to change the security table to ...

LOAD * INLINE [

ACCESS, USERID, PASSWORD, BU, REGION, AREA, BU_AREA

ADMIN, 1, 1,,,,

USER, 2, 1,BU1,EUROPE,NW EUROPE,BU1/NW EUROPE

USER, 2, 1,BU1,EUROPE,S EUROPE,BU1/S EUROPE

USER, 2, 1,BU2,EUROPE,NW EUROPE,BU2/NW EUROPE

];

... and then create the BU_AREA field in your data

data:

LOAD *, PF & '/' & AREA AS BU_AREA INLINE [

PF, REGION, AREA, VALUE

flipside

PS Looking at it again, you can probably change the security table like this ...

LOAD *, BU & '/' & AREA AS BU_AREA INLINE [

ACCESS, USERID, PASSWORD, BU, REGION, AREA

ADMIN, 1, 1,,,

USER, 2, 1,BU1,EUROPE,NW EUROPE

USER, 2, 1,BU1,EUROPE,S EUROPE

USER, 2, 1,BU2,EUROPE,NW EUROPE

];

... but I haven't tested this yet.

Re: Section Access problem

giakoum — Fri, 11 Jan 2013 11:42:35 GMT

Excellent idea, thank you!