Section Access problem..

[#1]

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

[#2]

What is the password for the file?

[#3]

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

[hic · Accepted solution]

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

HIC

[#5]

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

[hic]

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

[#7]

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

/Jonas