Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.

Section Access - a common business scenario

nick_scott
New Contributor III

Section Access - a common business scenario

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):

RoleUserPasswordPermissions
General ManagerAlexAlexAll data
Regional ManagerPetePeteAssociated regional sales and all Global sales
DouglasDouglasAssociated regional sales and all Global sales
Sales RepresentativeSarahSarahAssociated customer sales and all Global sales
DazDazAssociated 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,

Nick Scott.

Attachments
Version history
Revision #:
1 of 1
Last update:
‎04-20-2016 07:31 AM
Updated by: