Section Access - a common business scenario
The Section Access table enables developers to manage User authentication and authorization on an application. The use of the Section Access table, in conjunction with a "data field" and the selection of "Initial Data Reduction on Section Access" in the >>Settings >>Document Properties >>Opening enables the dynamic data reduction on the User opening an application.
A common security requirement is for Users not only to see data associated with their activity, but also to see comparative data at an enterprise level.
This often creates problems as there is often no natural association between the User and the enterprise data, which is at a higher level of granularity.
The attached document provides an illustration of two techniques for managing associations:
- Default Key - the creation of a "default key" (e.g. "X") in a Data Reduction field to create an association where a data table has no natural association; and
- Generic Key - the creation of a "generic key", which enables the application different levels of security on different tables, using a single Data Reduction field.
The Demo QlikView Application
Basic Section Access has been applied to the Demo QlikView application.
These are the User Roles, User names and Password(s):
|General Manager||Alex||Alex||All data|
|Regional Manager||Pete||Pete||Associated regional sales and all Global sales|
|Douglas||Douglas||Associated regional sales and all Global sales|
|Sales Representative||Sarah||Sarah||Associated customer sales and all Global sales|
|Daz||Daz||Associated customer sales and all Global sales|
The application uses a LinkTable script which I have previously posted to the community. The script and the data files are in the attached Zip.
Please post your comments,
Explore & Enjoy,