section access and the use of "dummy rows"

daveatkins — Fri, 27 Sep 2024 21:14:27 GMT

While this is no longer a problem in QlikSense, I wanted to ask and confirm that it is still a problem in QlikView...

An application exists already which provides data organized by a facility id which, previously was accessible to all. Now, the use case is that some new users will be added but they are only allowed to access 2 or 3 of the 40-50 facility ids.

What I WISH I could do is add section access with ADMIN role for the AD group that currently has access and then specify the new users to be restricted. But you can't do it like this

Section Access;

LOAD * INLINE [
ACCESS, NTNAME, RESTRICTFACILITY
ADMIN, ADGROUPNAME, *
USER, NEWPERSON, FACILITY001
];

Section Application;

because the * will only provide access for FACILITY001. I think I have to loop over the existing data in the load script and generate "dummy rows" like this:

LOAD * INLINE [
ACCESS, NTNAME, RESTRICTFACILITY
ADMIN, ADGROUPNAME, FACILITY001
ADMIN, ADGROUPNAME, FACILITY002
ADMIN, ADGROUPNAME, FACILITY003
USER, NEWPERSON, FACILITY001
];

Is this still how it works?

Even better would be if something like this worked:

LOAD * INLINE [
ACCESS, NTNAME, RESTRICTFACILITY
ADMIN, *, *
USER, NEWPERSON, FACILITY001
];

and yes, I have read the documentation and worked on this for years so a simple "yes, you have do the dummy rows" is fine if I have not missed some great solution.

Re: section access and the use of "dummy rows"

rubenmarin — Sat, 28 Sep 2024 06:41:27 GMT

Hi, to use the *, and have the * with access to all values, yes, you need to load all values first.

There is an alternative, creating a table between section access and the table with the RESTRICTFACILITY field, and create in that table the group of values, like:

SA_FACILITY: LOAD RESTRICTFACILITY, RESTRICTFACILITY as SA_FACILITY Resident TableName Concatenate (SA_FACILITY) LOAD RESTRICTFACILITY, 'ALL' as SA_FACILITY Resident TableName;

With this you can use SA_FACILITY in section access and just use 'ALL', you can also add other predefined goups that are commonly used in your SA.

topic section access and the use of "dummy rows" in QlikView

section access and the use of "dummy rows"

Re: section access and the use of "dummy rows"