topic Re: section access in QlikView

section access

Thu, 15 Sep 2011 06:39:19 GMT

Hi all,

group	user id	password	region	branch
admin	admin	admin1	*
user	priya	priya1	Kerala	*
user	priya	priya1	Tamil Nadu	Only "Chennai"

For a same user id and passwrd i want the above condition. i tried it but its not working. anybody facing the same problem.

Any solution

Thanks,

section access

Thu, 15 Sep 2011 06:57:18 GMT

Hi,

at the moment i can tell you to see th help in qlikview searching sectiona access, then if there is not already answer i post an example.

In the Help there is an usefull example, maybe your problem is caused from the wrong use of '*'.

C u,

Stefano.

section access

Thu, 15 Sep 2011 07:15:47 GMT

Hi Stefano

I searched for it. but i cant get the example what i need. will u plz post example application. if u hav please.

thanks,

Re: section access

Miguel_Angel_Baeyens — Thu, 15 Sep 2011 09:09:57 GMT

Hi Usha,

What you need is to add all possible values for Kerala. The "*" in section access doesn't mean "all values" but "all values listed in section access" so ADMIN in your example would not be able to see Region = Delhi (for example), but only Regions "Kerala" and "Tamil Nadu", and only Branch = "Chennai".

Check the following script:

STAR IS *;
SECTION ACCESS;
LOAD * INLINE [
GROUP, USERID, PASSWORD, REGION, BRANCH
ADMIN, ADMIN, ADMIN, *,
USER, PRIYA, PRIYA1, KERALA, BRANCH1
USER, PRIYA, PRIYA1, KERALA, BRANCH2
USER, PRIYA, PRIYA1, TAMIL NADU, CHENNAI
];
SECTION APPLICATION;
DATA:
LOAD * INLINE [
REGION, BRANCH
KERALA, BRANCH1
KERALA, BRANCH2
TAMIL NADU, CHENNAI
TAMIL NADU, BRANCH3
];

You need to create as many lines as possible different values under Region and Branch are. In this example, user "Priya" will see all Kerala region (branches 1 and 2) and Tamil Nadu branch Chennai, but not "Branch3".

You will find some posts that will help on this same exact subject here, here or here, among many many others. Apart from that, there is a very good document that details how section access works in the Documents section here.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica