Gustav Guldberg
QlikTech Inc
Revision 1 - 2010 June 08
2010 April 17
About this document
This document serves a compliment to the information on Section Access in the QlikView Reference Manual and is aimed towards users who are new to Section Access, to use it in addition to the Developer training and reference manual or just to brush up on old knowledge.
The examples are designed for QlikView Developer 9 but the script will work in QlikView Developer 8.50 SR3 and later.
**Note that this document does not cover the usage of Section Access for the thin clients (Plugin, Java and Ajax) or reloads via QlikView Publisher 8.50.x or QlikView
Server (Enterprise) Management console in 9.00.x. These topics will be covered in an upcoming guide and more advanced Section Access solutions.
Words of Warning
•
Before implementing Section Access in your document, backup your application. Incorrect syntax will render your document inaccessible and there’s no possibility of recovering the data or script.
•
It is good practice to work with multiple copies of the document to be able to revert back to an earlier document in case an error is made in the script.
Table of Contents
Introduction to Section Access .......................................................................................1
About this document .......................................................................................................2
Words of Warning .......................................................................................................2
Why use Section Access? ..............................................................................................4
How to setup and enable Section Access ......................................................................5
Hidden Script ..............................................................................................................5
Access Control ...........................................................................................................6
Section Access System Fields ...................................................................................6
Field used in the script for Section Access ................................................................7
ACCESS ................................................................................................................7
USERID ..................................................................................................................8
PASSWORD ..........................................................................................................8
SERIAL ..................................................................................................................8
NTNAME ................................................................................................................8
NTDOMAINSID ......................................................................................................8
NTSID ....................................................................................................................9
OMIT ......................................................................................................................9
REDUCTION ..........................................................................................................9
Define Section Access on document level .............................................................. 10
“Initial Data Reduction Based on Section Access” ............................................. 10
“Strict Exclusion” ................................................................................................. 11
“Prohibit Binary Load” ......................................................................................... 11
Security Settings on Document Level ..................................................................... 12
Reduce Data