topic Re: Data reduction doesn't work in App Development

Data reduction doesn't work

dafnis14 — Thu, 18 Oct 2018 11:53:39 GMT

Hi,

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

I have the following issues:

If I don’t add the line ADMIN,*,*, I cannot open the app, eventhough In the QMC I'm defined as RootAdmin.
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!

Re: Data reduction doesn't work

petter — Thu, 18 Oct 2018 12:04:44 GMT

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

Star is *;

Re: Data reduction doesn't work

petter — Thu, 18 Oct 2018 12:10:26 GMT

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/ScriptRegularStatements/Star.…

Re: Data reduction doesn't work

dafnis14 — Thu, 18 Oct 2018 12:25:13 GMT

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..)

Re: Data reduction doesn't work

petter — Thu, 18 Oct 2018 12:36:47 GMT

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.

Re: Data reduction doesn't work

dafnis14 — Thu, 18 Oct 2018 13:18:20 GMT

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 :-(..

Re: Data reduction doesn't work

dafnis14 — Thu, 18 Oct 2018 13:53:45 GMT

Thanks!

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

Re: Data reduction doesn't work

dafnis14 — Wed, 24 Oct 2018 11:54:30 GMT

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!