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

How does Section Access work internally ?

We are observing that the documents with section access are taking too much time to reload.

Is it something related to Section Acess ? Can somebody throw some light on what happens when a document with section access is reloaded ?

Abhinav

4 Replies
qlikviewajeet
Contributor III
Contributor III

solution 1: check ur section access code. all fields like ACCESS, USERNAME, PASSWORD must be in UPPER CASE

2 -  if this correction doesn't solve the problem, reduce the reload time .

3 - reduce possible session timeout. QVMS - Setup - QVS - Performance..

qlikviewajeet
Contributor III
Contributor III

section access works as per documents CALs u applied. document CALs means user access. first u authorized the user and user same user id in ur section access code. u read instructions in help manual which is in qlikview management console. u can see Help button on right side, below qlikview logo.....

Not applicable
Author

I was more interested in knowing if section access does something internally while loading data which is increasing my reload time ....because without section access the document reload is much faster.

Abhinav

Not applicable
Author

Although you can't see the section access table in the final datamodel it exists just like any other table within the model. If the section access table is very large then obviously loading it in will be slow. Also if you have fields within the section access table(s) then these will connect to the rest of the datamodel. If these fields cause large synthetic keys or circular references then they can slow down you reload also.

Try commenting out the section access statement and load the table as a normal data table and see what you get.

Matt