Section Access Question - Overlapping access

roebrich — Tue, 10 Apr 2018 14:59:24 GMT

Hi, I would like to know if this scenario is possible.

Assume the following:

Extra rows were created above User1 for "Dummy" user that lists all possible values for Dim1 and Dim2
Dim1 and Dim2 have more values not listed in the sample below.
Below is how the section access table is written for User1

ACCESS	NTNAME	DIM1	DIM2
USER	User1	*	DIM2VALUE1
USER	User1	*	DIM2VALUE2
USER	User1	*	DIM2VALUE3
USER	User1	DIM1VALUE1	*

I know that here, User1 will have access to all values for DIM1 and DIM2. But what I would like to happen is that the user will have access to all DIM1 values related to DIM2 values 1-3, but for DIM1VALUE1 it should have access to all DIM2 values related to it. Like DIM1VALUE1 can have DIM2VALUE4, I want to be able to see that, but if DIM1VALUE2 also have DIM2VALUE4 I don't want to see that. Is this possible with section access? If not, do you have an advice to how security should be implemented here?

Thanks,

Roebrich Perez

topic Section Access Question - Overlapping access in QlikView

Section Access Question - Overlapping access