Section Access does not work for USER (ACCESS) and * values.

vishal_goyal — Thu, 14 Mar 2024 19:12:51 GMT

Hi,

I am facing a strange issue while applying Section access in my QlikSense App.

I want userA to have access to all clients while userB restricted to a specific client.

When i provide all values of reduction field for userA in each row of section access script , it works fine. However when i appply * it starts misbehaving and filters only to reduction value of userB.

Example:

I have only 3 distinct values for my data model field SA_PART_SHORT_NAME (JPMC,BARC and CAM). Below section script works fine for both userA and userB.

Section Access;
Load * inline [
ACCESS, USERID, SA_PART_SHORT_NAME
USER, INFOCLOUD\userA, JPMC

USER, INFOCLOUD\userA, BARC

USER, INFOCLOUD\userA, CAM

USER, INFOCLOUD\userB, BARC
ADMIN, INTERNAL\SA_SCHEDULER,
];
Section Application;

However, when I change it to below, userA start giving me data only for BARC instead of all 3 values

Section Access;
Load * inline [
ACCESS, USERID, SA_PART_SHORT_NAME
USER, INFOCLOUD\userA, *

USER, INFOCLOUD\userB, BARC
ADMIN, INTERNAL\SA_SCHEDULER,
];
Section Application;

Am I missing something when trying to use * for userA ?

Thanks

Re: Section Access does not work for USER (ACCESS) and * values.

Lisa_P — Thu, 14 Mar 2024 23:09:59 GMT

The * will only represent the other values in the table.

So in SA Table 1, the SA_PART_SHORT_NAME values are JPMC, BARC, CAM

in SA Table 2, the only SA_PART_SHORT_NAME value is BARC

Re: Section Access does not work for USER (ACCESS) and * values.

vishal_goyal — Fri, 15 Mar 2024 01:31:04 GMT

That really helps... I was under impression that * denotes all possible values in Data Model.

topic Section Access does not work for USER (ACCESS) and * values. in Management & Governance

Section Access does not work for USER (ACCESS) and * values.

Re: Section Access does not work for USER (ACCESS) and * values.

Re: Section Access does not work for USER (ACCESS) and * values.