topic Re: Section Access- Reduce data for only some objects in QlikView

Section Access- Reduce data for only some objects

Tue, 04 Feb 2014 08:53:25 GMT

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?

Re: Section Access- Reduce data for only some objects

Tue, 04 Feb 2014 09:10:32 GMT

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"

Re: Section Access- Reduce data for only some objects

Tue, 04 Feb 2014 09:17:07 GMT

In this case: * - all groups in his department

Re: Section Access- Reduce data for only some objects

Tue, 04 Feb 2014 09:21:57 GMT

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

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

Re: Section Access- Reduce data for only some objects

agilos_mla — Tue, 04 Feb 2014 09:24:11 GMT

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

Re: Section Access- Reduce data for only some objects

agilos_mla — Tue, 04 Feb 2014 09:31:33 GMT

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.

Re: Section Access- Reduce data for only some objects

Tue, 04 Feb 2014 17:41:00 GMT

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.

Re: Section Access- Reduce data for only some objects

Wed, 05 Feb 2014 11:10:52 GMT

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

Re: Section Access- Reduce data for only some objects

hugocesar — Thu, 04 Dec 2014 14:19:52 GMT

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.