4 Replies Latest reply: Apr 13, 2012 6:39 AM by Matthew Fryer RSS

How does Section Access work internally ?

Abhinav Agarwal

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

  • How does Section Access work internally ?
    qlikviewajeet

    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..

  • How does Section Access work internally ?
    qlikviewajeet

    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.....

  • How does Section Access work internally ?
    Abhinav Agarwal

    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

  • How does Section Access work internally ?
    Matthew Fryer

    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