Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?
Maybe you could find here more: http://community.qlik.com/groups/german-user-group/blog/2014/07/08/section-access
- Marcus
I already had a look on most of this articles. Couldn´t find a solution for my problem.
But many thanks to you.
Thomas
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
Hi Marcus, thanks for your answer. Helps me to discuss this topic in the project team to get a decision.
BR Thomas