topic Re: Access to data outside Section Access in QlikView

Access to data outside Section Access

thkarner — Thu, 25 Sep 2014 12:32:03 GMT

Hi,

I´ve a regional structure in my data model organized in a dimension table.

The levels are top-down: country, region, area, sub-area, segment

Sales persons should have access only to their area! But they also should see some benchmark figures of country and other regions for comparision.

If I reduce data with section access on level of area for sales persons I don´t have access to data on country and region level.

At the moment I think on pre-aggregating benchmark figures in the script and add this data separatley to the data model.

Has anyone ideas to solve this requirement with another technique?

Thanks for your help in advance.

Regards,

Thomas

Re: Access to data outside Section Access

marcus_sommer — Thu, 25 Sep 2014 14:19:47 GMT

Have a look here: http://community.qlik.com/search.jspa?q=section+access&author=%2Fpeople%2F4003&type=post. If you have no performance-problems with the additionally pre-aggregating it's a good solution because it's simply - complex data-structures and autorizations make a lot of effort to develop and maintain them.

- Marcus

Re: Access to data outside Section Access

thkarner — Thu, 25 Sep 2014 14:59:22 GMT

Thanks. There is an interesting article from Henric where he mentions Aggregation-level access.

http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/09/methods-for-data-reduction

But I couldn´t find any details about the concept and how to implement it technically.

Do you have some details?

Re: Access to data outside Section Access

marcus_sommer — Thu, 25 Sep 2014 16:18:21 GMT

Maybe you could find here more: http://community.qlik.com/groups/german-user-group/blog/2014/07/08/section-access

- Marcus

Re: Access to data outside Section Access

thkarner — Thu, 25 Sep 2014 17:20:24 GMT

I already had a look on most of this articles. Couldn´t find a solution for my problem.

But many thanks to you.

Thomas

Re: Re: Access to data outside Section Access

marcus_sommer — Fri, 26 Sep 2014 06:02:10 GMT

Hi Thomas,

from: http://community.qlik.com/blogs/qlikviewdesignblog/2014/06/09/methods-for-data-reduction

It is difficult to achieve aggregation-level access within one single application, so it is better to solve this problem using two applications: One with detailed data that you reduce using a reducing field, and a second unreduced with aggregated data for all countries.

And it's my opinion, too. I have already build a very complex authorization which runs productively but the effort to build and validate it is enormous and maintaining is a horror and with our next releases I will split these app into two apps and have two very easy section access

- Marcus

Re: Re: Access to data outside Section Access

thkarner — Fri, 26 Sep 2014 07:34:15 GMT

Hi Marcus, thanks for your answer. Helps me to discuss this topic in the project team to get a decision.

BR Thomas