Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Highlighted
dafnis14
Contributor III

Data reduction doesn't work

Hi,

I created  a section access which is based on a file I prepared:

USERSPERMS.png

I have the following issues:

  1. If I don’t add the line ADMIN,*,*, I cannot open the app, eventhough In the QMC I'm defined as RootAdmin.
  2. Data is not reduced. The users see all product groups.

Here is the script:

Star = '*';

section access; 

UserPerms:

LOAD * inline [ 

ACCESS,USERID,PRODUCTGROUPID

ADMIN,*,*

ADMIN, INTERNAL\SA_SCHEDULER,*

]; 

Concatenate (UserPerms)

LOAD

ACCESS,

USERID,

PRODUCTGROUPID

FROM $(vPathFinalData)UsersPermissions.qvd]

(qvd);

section application; 

ItemGroup:

LOAD ItmsGrpCod,

ItemGroupName,

ItmsGrpCod as PRODUCTGROUPID

FROM

$(vPathFinalData)ItemGroup.qvd]

(qvd);

What am I doing wrong???

Thanks!

1 Solution

Accepted Solutions
MVP
MVP

Re: Data reduction doesn't work

It is necessary for some organizations and businesses to even restrict what the RootAdmin is allowed to view of data. That's why a RootAdmin has to be given explicit DATA-access in SECTION ACCESS even though a RootAdmin has unrestricted access to all resources (except data) on a Qlik Sense site.

7 Replies
MVP
MVP

Re: Data reduction doesn't work

I don't know if that will solve you problem but the correct syntax for star is:

Star is *;

MVP
MVP

Re: Data reduction doesn't work

Actually I think it IS your problem since the documentation says that if you don't specify  STAR IS '*';   then  STAR IS; is assumed meaning that star is not considered a wildcard:

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptReg...

dafnis14
Contributor III

Re: Data reduction doesn't work

Hi Petter,

I corrected as you suggested, Thanks!.

But why am I still getting the "access denied" message if I remove the line:

ADMIN,*,*

(I still didn't ask the users to try..)

MVP
MVP

Re: Data reduction doesn't work

It is necessary for some organizations and businesses to even restrict what the RootAdmin is allowed to view of data. That's why a RootAdmin has to be given explicit DATA-access in SECTION ACCESS even though a RootAdmin has unrestricted access to all resources (except data) on a Qlik Sense site.

dafnis14
Contributor III

Re: Data reduction doesn't work

Hi Petter,

After fixing the Star is, the user ZZZZ sees the data of user YYYY  as well.

I guess I'm still missing something  :-(..

dafnis14
Contributor III

Re: Data reduction doesn't work

Thanks!

I'll open a new thread for my other issue..

dafnis14
Contributor III

Re: Data reduction doesn't work

Hi petter-s

Would like your opinion about the behavior I described in my "correct answer":

Data reduction: user sees other user's data

Is the issue I described expected?

Thanks!