Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..
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.....
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
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