topic Security - Dynamic Data Reduction in QlikView

Security - Dynamic Data Reduction

Fri, 04 Sep 2009 16:59:23 GMT

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?

Security - Dynamic Data Reduction

prieper — Fri, 04 Sep 2009 23:38:50 GMT

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

Security - Dynamic Data Reduction

Anonymous — Sat, 05 Sep 2009 02:12:28 GMT

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];

Re: Security - Dynamic Data Reduction

chematos — Thu, 12 Sep 2013 13:05:46 GMT

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