topic Re: Multiple Section Access in QlikView

Multiple Section Access

jarebpat — Wed, 16 Jan 2013 14:31:52 GMT

I need help with a Section Access issue. My current setup is working fine with the Section Access Table being sourced from Publisher in my script, depending what priviledges you have, you will only see certain warehouses.

On top of that I need to get a second Section Access table to be controlling the data access on the rep level. I tried to add a second section access table and it doesnt work. Tried using the same but with added column and tried a new Section Access Table....same results.

I've read here on the community that only one Section Access Table is allowed? Is this correct?

Here is sample of the script:

Section Access;
LOAD ACCESS, NTNAME, OMIT, GROUP, CRMSALESOFFICE
FROM [http://qvs01:4780/QMS/AuthTable] (html, utf8, embedded labels, table is [Business Overview]);
Section Application;
SecurityLink:
Load * Inline [
GROUP, Sales Office Name
ALL, DAR,
ALL, MON,
ALL, OTT,
ALL, TOR,
ALL, LON,
ALL, WPG,
ALL, EDM,
ALL, CAL,
ALL, VAN,
ALL, NAT,
ALL, SER,
BRANCHMNGRS, DAR,
BRANCHMNGRS, MON,
BRANCHMNGRS, OTT,
BRANCHMNGRS, TOR,
BRANCHMNGRS, LON,
BRANCHMNGRS, WPG,
BRANCHMNGRS, EDM,
BRANCHMNGRS, CAL,
BRANCHMNGRS, VAN,
BRANCHMNGRS, SER,
BRANCHMNGRS, CAL,

];

I want another one for reps like:

];

Thanks,

Re: Multiple Section Access

danielrozental — Wed, 16 Jan 2013 14:59:33 GMT

Yes, you should only use one section access table. You should look into combining both into a single field.

Re: Multiple Section Access

jarebpat — Wed, 16 Jan 2013 16:12:22 GMT

Thanks. Any suggestions on what to use?

They are on two different tables, currently one is being filtered based on the Section Access. The second table has the other field I need to filter, but this creates loops.

Re: Multiple Section Access

Wed, 05 Jun 2013 15:48:21 GMT

Did you ever work out how to do this, I'm facing this exact same issue and wondering best method to implement?

Cheers,

Nigel.

Re: Multiple Section Access

jarebpat — Wed, 05 Jun 2013 15:55:54 GMT

Yes. I have used a different section access table. One that has the rep which in turn locks down the data and then which warehouse he is able to see.

I have also split the file, one that hits the warehouse level and the other that hits the rep level as mentioned above……still not the best fix….I think the best would be to make a “Group” to rep to warehouse to rep middle table….that would give me a one file….

Regards,

Jareb