Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vikasmahajan
Honored Contributor III

Section Access Testing in Qlik Sense Server ( Dec 2017 release)

Hi All ,

trying following simple section access script in Qlik Sense gives error access denied ?  is there issues with script ?  or Qlik Sense is not still allowing for section access

Section Access;

LOAD

    UPPER("ACCESS") as ACCESS,

    UPPER("USERID") as USERID,

    UPPER(LCO) as LCO

    INLINE [

ACCESS, USERID, LCO

ADMIN, AA\ADMIN1, *

USER,    AA\USER01, B

USER,    AA\USER01,  C

USER,    AA\USER01,  D

USER,    AA\USER01,  E

USER,    AA\USER01,  F

USER,    AA\USER01,  G

USER,    AA\USER01,  H

USER,    AA\USER01,  I

USER,    AA\USER01,  A

USER,    AA\USER01,  J

USER,    AA\USER01,  K

USER,    AA\USER01,  L

USER,    AA\USER01,  M

ADMIN, AA\ADMIN2,            *

ADMIN, INTERNAL\sa_scheduler, *

];

SECTION APPLICATION;

LOAD

    UPPER(LCO) as LCO,

    Score

    INLINE [

    LCO,  Score

A,    1

B,    2

C,  3

D,    4

E,    5

F, 6

G, 7

H, 8

I,  9

J, 10

K,      11

L,  12

M,      13

];

1 Solution

Accepted Solutions
Employee
Employee

Re: Section Access Testing in Qlik Sense Server ( Dec 2017 release)

I suggest two things for troubleshooting.

  1. Load section access table as a normal data table, and validate that it is properly defined and links to your data model as expected.
    • Comment out SECTION ACCESS line in your script
    • Comment out SECTION APPLICATION line in your script
    • Reload to make section access table a visible entity in your data model

  2. Validate your userid
    • Validate in QMC what userid your user is known by
    • Visualize userid by using OSUser() in a sheet object
    • Update section access as required to match your userid


6 Replies
agigliotti
Honored Contributor II

Re: Section Access Testing in Qlik Sense Server ( Dec 2017 release)

which user are you trying to connect with?

rittermd
Honored Contributor

Re: Section Access Testing in Qlik Sense Server ( Dec 2017 release)

Is AA the actual User Directory value that appears in your QMC when you look at your users?

Are these users actually defined in the QMC?

As Andrea asked.  Which user were you testing with?  That might be helpful.

vikasmahajan
Honored Contributor III

Re: Section Access Testing in Qlik Sense Server ( Dec 2017 release)

I have tested  my user id as well  bpcldev\vikas.onkar.mahajan  with admin option but it shows access denied message in qvf.

Vikas

andrpfist
New Contributor

Re: Section Access Testing in Qlik Sense Server ( Dec 2017 release)

Hi Vikas

Try using NTNAME instead of USERID. Userid reflects not to the username supplied by ntlm.

Cheers

Andy

Employee
Employee

Re: Section Access Testing in Qlik Sense Server ( Dec 2017 release)

I suggest two things for troubleshooting.

  1. Load section access table as a normal data table, and validate that it is properly defined and links to your data model as expected.
    • Comment out SECTION ACCESS line in your script
    • Comment out SECTION APPLICATION line in your script
    • Reload to make section access table a visible entity in your data model

  2. Validate your userid
    • Validate in QMC what userid your user is known by
    • Visualize userid by using OSUser() in a sheet object
    • Update section access as required to match your userid


vikasmahajan
Honored Contributor III

Re: Section Access Testing in Qlik Sense Server ( Dec 2017 release)

Thanks Working as per your steps

Vikas