Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
rbrown24
New Contributor II

Section Access Uhhggg

Hi all I am attempting to tackle section access set up and it isn't going how I expect: Any help you can provide would be great.

Goal: 

I need to setup access so that a person can only see data related to there specific department

what I have tried:

1) I created a security name table using an employee username, assigned password and the department they can access. here's an example:

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, DEPARTMENT

  ADMIN,ADMIN, ADMIN1, *

  ADMIN, RBRXXX1, 34561,VBMC EMERGENCY DEPT

  USER, USER, USER1, PHC EMERGENCY DEPT

];

Section Application;

  DepartmentDSC, DEPARTMENT

  PHC EMERGENCY DEPT, PHC EMERGENCY DEPT

  VBMC EMERGENCY DEPT, VBMC EMERGENCY DEPT

LOAD * INLINE [

];

2) I checked off 'Initial Data ReductionBased on Section Avccess'>Strict exclusion within the document properties and 'Opening' tab

The issues I have had:

1) when I test login to qlikview it only shows the department Name as a selection op[tion but NO data associated to that department

2) when I test login to qlikview it shows me all the data and ignores the section access

3) when I try to refresh the data on the server side it fails to reload and I receive an error saying it cannot access

Helllppppppp

3 Replies
Highlighted

Re: Section Access Uhhggg

Have you seen this document by marcus_sommer which brings together most resources on Section Access into one set of links.

Section Access

Highlighted

Re: Section Access Uhhggg

A couple of possible causes for your issues:

2) when I test login to qlikview it shows me all the data and ignores the section access

         If testing on the desktop client and switching between users, you will need to fully exit QlikView to be able to change user, as the user details are retained if you just reload the same application.

3) when I try to refresh the data on the server side it fails to reload and I receive an error saying it cannot access

     The service account that is running the QlikView Distribution Service, must be listed in the Secvtion Access script as an admin user with full access to all data. Otherwise section access will only load data that the service account login has access to, and data will be missing for other users.

This may also cause the missing data you are seeing in Q1 when I test login to qlikview it only shows the department Name as a selection op[tion but NO data associated to that department

Highlighted
rbrown24
New Contributor II

Re: Section Access Uhhggg

I haven't seen it but I will take a look and if I have additional questions or have difficulty I will reach out for help again, thankyou for your timely response I appreciate the help