Security - Dynamic Data Reduction

[#1]

Hi,

I am referring to chapter 30.8 of the QlikView Reference Manual (Version 8.5).

I tried the example in which the available field values depend on the login and it worked.

But I have some problems when I want to restrict several values in more than one field.

section application;
star is *;
load * inline
[DEPT,Company, Year
IS, 10001, 2006
IS,10002, 2007];

The table is linked via DEPT to the table in Section Access. When I Iog in with the user I can only see data where Company='10001' and Year='2006' or Company='10002' and Year='2007', but not for example Company='10002' and Year='2006'. One solution would be to write all possible combinations in a table, but that could get very time-consuming.

Any other suggestions how to handle this issue?

[prieper]

Hi,

think you have to write all combinations. If there are more users having the same combinations, it may make sense group them and then to assign the rights to the groups.

HTH

Peter

[Anonymous]

I think it's a question about the data model. Do you really need Company and Year in the same logical table? I think it should be like this:

section application;
star is *;
Table1:
load * inline
[DEPT,Company
IS, 10001
IS,10002];

Table2:
[Company, Year
10001, 2006
10002, 2007];

[chematos]

I wolud try something like Michael says, but like this:

Table1:
load * inline
[DEPT,Company
IS, 10001
IS,10002];

Table2:

[DEPT,Year

IS, 2006

IS,2007];

hope this helps