topic Re: Section Access problem.. in QlikView

Section Access problem..

Mon, 04 Mar 2013 17:08:54 GMT

Hi!

I am at loss..If anyone could tell me why this section access solution dont work I would be most gratefull.

What I am doing is creating a generic key in order to apply section access on many dimension.

The problem for me is that all the users can see all the data.

I have attached a qvw file that contains the script and some mock data.

Regards

Jonas

Re: Section Access problem..

Mon, 04 Mar 2013 17:24:38 GMT

What is the password for the file?

Re: Section Access problem..

Tue, 05 Mar 2013 07:26:25 GMT

ops my bad... 😃 Admin is 1 and users 2,3,4

Re: Section Access problem..

hic — Tue, 05 Mar 2013 07:59:58 GMT

Try changing the reducing field "Auth" to "AUTH". All Section Access fields should be in upper case.

HIC

Re: Section Access problem..

Tue, 05 Mar 2013 08:06:32 GMT

And of course the solution is as simple as that...thx alot!

On a more architectural note, is this the best way to go when trying to achieve section access on many dimensions? This is just a mock-up ofc and the real app have to filter on 6 dimensions making the security script 6*6=36 seperate loads.

Thx again

Re: Section Access problem..

hic — Tue, 05 Mar 2013 08:11:34 GMT

Yes, you need to channel the reduction of all fields through one single authorization key. And Generic keys is the way to go if you want symbols like "ALL" in your reduction.

See more on

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/02/complex-authorization

HIC

Re: Section Access problem..

Tue, 05 Mar 2013 10:59:51 GMT

hm, then i guess i have to limit the security requierments instead...making that many loads to the fact table will be cumbersome...

/Jonas