Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Section Application do not work in Access Point

I have Section Access and Section Application working in a QlikView app when the users open from Desktop. The data is limited by the Cost Center and my script has a list of users and which cost center each one has access to.

As I said, when they open from Desktop it works perfectly, each user can see only the cost centers they are assigned to see. However when they open from the browser It does not work. The Section Access portion works, It only allowed the users that can access the application. The part that does not work is the Section Application. All users that are in the list can see all cost centers.

Do you guys know what is going on?

1 Solution

Accepted Solutions
Not applicable
Author

Problem resolve a few weeks ago, but just now I had time to report it. The problem is Section Access works fine if you do not load the access table from a resident table, if you do, it will not work. Maybe is a bug, maybe is a natural behavior, but by putting the load table directly after the section access made my code to work also in access point.

View solution in original post

6 Replies
Miguel_Angel_Baeyens

Hello Igor,

When you open a document on the server or by client, regardless the ACCESS you have set for them in Section Access, all users are dealt as USER (even when you have set them as ADMIN in the ACCESS field). My guess is that they are able to open the document on Desktop since they may be behaving as ADMIN.

I'd first try manually to select some of the users that cannot see their information, go to menu File, Reduce Data, and select "Keep Possible Values" to see what actual information is the user seeing.

If that works (if the user sees the information he is supposed to) I'd check that in the Settings menu, Document Properties, Opening, "initial Data Reduction" is checked and so it is "Strict Exclusion", and try to log in with any user, now that the reduction is taking place. As any user can log in and see all data, I'm assuming that instead is checked "Initial Selection based on Section Access".

Hope this helps.

Not applicable
Author

Hi Michael,

Thanks for your reply, I appreciate it.

I tried to use the Keep Possible Values in desktop and that shows me only the Costs Centers I suppose to see. However, when I open the app in the browser It shows me everything.

I already have the "Initial Data Reduction Based on Section Access" option checked. However if I check "Strict Exclusion" and republish I am no longer able to even open the app. It keeps asking me for my username and password instead of getting from Active Directory.

Any other thoughts?

Thanks again.

Miguel_Angel_Baeyens


Igor Alcantara wrote:I already have the "Initial Data Reduction Based on Section Access" option checked. However if I check "Strict Exclusion" and republish I am no longer able to even open the app. It keeps asking me for my username and password instead of getting from Active Directory.


This points me to the fact that, somewhat, the section access and the rest of the data are not linked. Strict Exclusion means that, if after reducing there is no data available, the user will not be able to access the document. If all users had records available, then Strict Exclusion show only the records corresponding to them, instead of everything.

Actually, the user and password it keeps you asking should be the one corresponding to section access, and not the Active Directory credentials. You can easily check this if after a failed document login the user is still able to see the documents in the Accesspoint (in the webpage, above right will appear "LOGGED IN AS:" and the username in the form DOMAIN\username.

Perhaps obvious but are you reducing data (keeping possible values) using the same exact field you are using in the section access?

Hope this helps

Bill_Britt
Former Employee
Former Employee

In you have "Strict Exclusion" check you can not use blanks (null) in you table. A blank is the same as no access. You will need to use a * .

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Miguel_Angel_Baeyens

I think it's worth noting that in addition to the above, the "*" in section access doesn't mean "all possible values" but "all listed values within the fieldname in section access". Assume the following:

STAR IS *; SECTION ACCESS; LOAD * INLINE [ACCESS, USERID, PASSWORD, REDUCTIONADMIN, ADMIN, ADMINUSER, USER, USER, *]; SECTION APPLICATION; DATA:LOAD * INLINE [REDUCTION, VALUEA, 1B, 2];


When opening on the Desktop, the ADMIN will be granted access even with strict exclusion, because of the ADMIN value in the ACCESS field, while USER will not, because the "*" in the REDUCTION field lists no values, actually. If the document is opened in server, none of them will be granted access, because ACCESS field is not taken into account, so the ADMIN user is now a USER access.

Hope that helps

Not applicable
Author

Problem resolve a few weeks ago, but just now I had time to report it. The problem is Section Access works fine if you do not load the access table from a resident table, if you do, it will not work. Maybe is a bug, maybe is a natural behavior, but by putting the load table directly after the section access made my code to work also in access point.