topic Re: section access script in QlikView

section access script

Thu, 30 Oct 2014 07:19:53 GMT

hi

i am trying to deploy some security policies using section access. in one of them i want to let each group(active directory group) access data of joust one month, i mean group IT can just see 10th month and 2HR Group to see 11th. but there is a user (m.azizi) whom he is one of members of IT group and he should see both 10th and 11th data.

i have wrote this code but it is not true.

Section Access;

LOAD * INLINE [

ACCESS, NTNAME

ADMIN, TAKSARAN\IT

USER, TAKSARAN\2HR

];

section Application;

LOAD * INLINE [

NTNAME , d Month

TAKSARAN\M.AZIZI,10

TAKSARAN\M.AZIZI,11

TAKSARAN\IT, 10

TAKSARAN\2HR , 11

];

Re: section access script

Thu, 30 Oct 2014 07:36:13 GMT

Hi,

Here [d Month] SHOULD BE IN Capitals otherwise it won't work.it should be like a [D MONTH]

if your source is like [d Month] just use upper([d Month])

LOAD * INLINE [

NTNAME , [D MONTH]

TAKSARAN\M.AZIZI,10

TAKSARAN\M.AZIZI,11

TAKSARAN\IT, 10

TAKSARAN\2HR , 11

];