Databases Reference
In-Depth Information
In this exercise, we reduce the data model based on a single
field. To reduce the data model on multiple fields, we can
simply add another reduction column to the section access
table and add a bridge field to the data model.
One important caveat to be aware of in this scenario is that the
reduction will be performed over the intersection of all fields.
If, for example, we give a user access to the
Domestic, US
Carriers Only
flight type and to the
Jet
engine type, the
user will only be able to see domestic flights carried out by
US carriers using a jet-powered aircraft. Any flights that were
made using another engine type will be excluded.
Although we have now finished the script part of setting up section access with
reduction fields, we will need to make a few more changes before we can see the
results. Let's head over to the frontend.
Initial data reduction
We will need to tell QlikView to perform an
Initial Data Reduction
when opening
the document. When using initial data reduction, QlikView removes all of the data
the user does not have access to, based on the authorizations in section access.
Using initial data reduction is very important. Not using
it means that everyone with access to the document has
access to all of the data. This means he entire point of
using section access is all but lost.
Let's follow these steps to set up initial data reduction for our document:
1.
Open the
Document Properties
window by pressing
Ctrl
+
Alt
+
D
.
2.
Go to the
Opening
tab, and select the
Initial Data Reduction Based on
Section Access
checkbox.
3.
Make sure that the
Strict Exclusion
checkbox is checked.
4.
Check the
Prohibit Binary Load
checkbox (seen in the following screenshot).
5.
Click on
OK
to close the
Document Properties
dialog.
6.
Go to
File | Save
in the menu to save the document.