Qlik sense: Section Access issue using email as USERID

[#1]

Hi,

I am trying to embed a mashup in a web page.

The customer logs into the web site and selects an option from a drop down menu that takes them to the mashup.

Unfortunately they are getting an "access Denied" error.

In my section access tab, i have the following code.

USER_TEST:

LOAD

    ACCESS,

    USERID,

    REDUCTION;

SQL SELECT 'USER' as ACCESS, upper([email]) as USERID, [AnalysisGroup] as REDUCTION

FROM ReportingDatabase.dbo."User"

where RoleId in (30,40);

section access;

Load  * inline [

ACCESS, USERID, REDUCTION

ADMIN,ABC\BLOGG1, *

];

section application;

DROP TABLE USER_TEST;

The USERID data takes the form of "joe.blogs@customer.org.uk"

The "ABC\BLOGGS1" line gives me the access to edit the qliksense app, without locking me out.

Can i mix my USERID data? Eg AD accounts and email addresses?

Any suggestions as to what i am doing wrong would be appreciated.

Thanks,

Shane

[MK9885]

DYNAMIC SECTION ACCESS

Start is *;

Section Access;

USER_TEST:

LOAD

    'USER' as ACCESS,

   upper([email]) as USERID,

   [AnalysisGroup] as REDUCTION;

SQL SELECT

FROM ReportingDatabase.dbo."User"

where RoleId in (30,40);

Load  * inline [

ACCESS, USERID, REDUCTION

ADMIN,ABC\BLOGG1, *

ADMIN, SERVICEACCOUNT\BLOGG1, *

USER,USER\BLOGG1, USA

];

section application;

You can try above script?

And yes, you should load the table before or can store into QVD so that SA can match the fields

USERROLE:

LOAD

     'USER' as ACCESS,

   upper([email]) as USERID,

   [AnalysisGroup] as REDUCTION;

LOAD

    'USER' as ACCESS,

   upper([email]) as USERID,

   [AnalysisGroup] as REDUCTION;

SQL SELECT

FROM ReportingDatabase.dbo."User"

where RoleId in (30,40);

Store USERROLES into ........qvd

[#3]

Hi,

Thanks for getting back to me. Sorry to say your solution does not allow me to see the mashup in our web portal. I am still getting an Access Denied error.

[MK9885]

Hi,

It will work normally but I have never worked on Mashup. So couldn't help much, sorry.