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.