Section Access- Reduce data for only some objects

[#1]

Hi all!

My customer wants to use Section Access on their reports, but it isn't usual Section access.

I have the following structure:

On example, we have 2 kind of users:

1) chief of department

2) manager of group

I should ruduce data by the following rules:

USER	Department	Group
chief of department1	Department1	*
chief of department2	Department2	*
chief of department3	Department3	*
managers of group1_1	Department1	Group1_1
managers of group1_2	Department1	Group1_2
managers of group1_3	Department1	Group1_3
managers of group2_1	Department2	Group2_1
managers of group2_2	Department2	Group2_2
managers of group2_3	Department2	Group2_3
managers of group3_1	Department3	Group3_1
...	...	...

But!! I have3 pivote tables on my reports, which shows us ranks:

1) Rank departments;

2) Rank groups;

3) Rank offices.

So,chief of department1 must see all  departmens on object 'Rank departmens'' for analisys ranks. But in object "Rank groups" he must see only groups on his departments1.

Managers of group have the same rule:

managers of group1 must see all groups on object "Rank groups", but he can only offices on his group in the object "Rank offices".

The reducing data must look like the following for user "chief of department1":

The object "Rank departments":

Department	Expression1	Expression2	Rank
Department1	275	1,2	2
Department2	350	1,8	1
Department3	100	0,9	3

The object "Rank groups":

Group	Expression1	Expression2	Rank
Group1_1 (Department1)	275	1,0	2
Group1_2 (Department1)	50	0,99	3
Group1_3 (Department1)	800	0,97	1

I must reduce data throught Section Access, not any Selected field and block field by Action, becouse data must be reduced.

Do you have any idea for resolving this problem?

[#2]

If chief of department1 must see all  then:

USER	Department	Group
chief of department1	Department1
chief of department2	Department2
chief of department3	Department3
managers of group1_1	Department1	Group1_1
managers of group1_2	Department1	Group1_2
managers of group1_3	Department1	Group1_3
managers of group2_1	Department2	Group2_1
managers of group2_2	Department2	Group2_2
managers of group2_3	Department2	Group2_3
managers of group3_1	Department3	Group3_1
...	...	...

* - it is not "see all"

[#3]

In this case: * - all groups  in his department

[#4]

* не будет откатывать "показать всё"  при последующих загрузках, если ничего не задать для  учётки, то правильнее будет откатывать и не проходиться лишний раз.

И попробуй через колонку OMIT

[agilos_mla]

Konstantin,

Just keep in mind that * does not mean ALL. I explain.

Let's imagine that you have Groups A, B, C in Dept 1. You setup the section access as :

Chief            Dept_1 *

ManagerA      Dept_1      Group A

Manager B     Dept_1     Group B

Then using the *, the chief will only see the combination of the groups A and B found accross the section access, in the example above Chief will see Group A and B, not C ! Then keep the Group well empty to reach all Groups for the Chief.

HTH,

Michael

[agilos_mla]

The solution is through you model, you'll have to compute aggregates by Departments and fin a way that every department see the aggregates for the others but not the details.

Generally I do that by creating additonal column and a linktable wiht appropriate Key (Sorry I don't have any sample under the hand)

Maybe you could find sthg her : http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/25/hierarchy-authorization

Michael.

[#7]

Michael, thank you, but this post (http://community.qlik.com/blogs/qlikviewdesignblog/2013/11/25/hierarchy-authorization) doesn't resolve my problem, it is perfect solutione for generation permissions, but i need something for pseudo- reducing data.

[#8 · Accepted solution]

I have solution for this issue.

I should select the Initial Selection Based on Section Access checkbox and than get current fieldname and lock it throught Document Properties->Triggers->OnOpen.

And than i should add set analisys in some tables  with ranks

[hugocesar]

Hi Ksenia,

Thanks for sharing that. Would you give me an example of the set analisys. I did what you said but a i don´t know how use it in a set analisys expresions..

thanks a lot

César B.