topic Re: Section Access Help in QlikView

Section Access Help

satishkurra — Tue, 12 Apr 2016 20:42:09 GMT

Using the below section access script, i assume user ADAM has ADMIN access and he should be able to see all the data as i represented in * and User PETER should be able to see only JCPenney.

Not sure what is happening, when i log with ADAM, i see only JCPenney.

Can someone help me on the same.

In b/w the below things are taken care

I have “Initial Data Reduction Based on Section Access” and “Strict Exclusion” Ticked.

Section Access;

LOAD * Inline [

ACCESS, USERID, PASSWORD, LINK

ADMIN, ADAM, ADAM, *

USER, PETER, PETER, WALLMART

];

Section Application;

Provider:

LOAD * Inline [

LINK

JCPENNEY

WALLMART ];

Re: Section Access Help

trdandamudi — Tue, 12 Apr 2016 20:46:16 GMT

Do you have data for Wallmart in your dashboard ?

Re: Section Access Help

satishkurra — Tue, 12 Apr 2016 20:56:22 GMT

This is just a test data. I don't have data for JCPenney as well

Re: Section Access Help

trdandamudi — Tue, 12 Apr 2016 21:33:51 GMT

Satish,

Please try the attached and let me know. I used your data so when you login as :

Adam you will see all the data and when you login as Peter you will see only 'Wallmart'

if you want in "Security" tab you can also check "Admin Override Security"

Hope this helps.

Re: Section Access Help

settu_periasamy — Wed, 13 Apr 2016 03:11:43 GMT

Hi,

Remove '*' and try..

Re: Section Access Help

jagan — Wed, 13 Apr 2016 03:18:10 GMT

Hi Satish,

Check this links hope it helps you.

Authentication and Authorization in Qlikview

Various levels of security implementation using Section Access

Regards,

Jagan.

Re: Section Access Help

satishkurra — Wed, 13 Apr 2016 04:12:57 GMT

This is strange. * indicates all data right . any reason to remove *?

Re: Section Access Help

settu_periasamy — Wed, 13 Apr 2016 05:15:15 GMT

Hi Satish,

See here.. Re: Section Access "Star"

May be you can try like

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, LINK
ADMIN, ADAM, ADAM, *
USER, PETER, PETER, WALLMART
USER, USER,PASSWORD,JCPENNEY
];

Section Application;
Provider:
LOAD * Inline [
LINK
JCPENNEY
WALLMART
];

Re: Section Access Help

perumal_41 — Wed, 13 Apr 2016 05:45:13 GMT

use blank as per sethu said

for reference

Re: Section Access Help

avinashelite — Wed, 13 Apr 2016 05:46:03 GMT

try like this

Section Access;

LOAD * Inline [

ACCESS, USERID, PASSWORD, LINK

ADMIN, ADAM, ADAM, *

USER, PETER, PETER, WALLMART

];

Section Application;

START is *;

STAR is *;

Provider:

LOAD * Inline [

LINK

JCPENNEY

WALLMART ];

Re: Section Access Help

settu_periasamy — Wed, 13 Apr 2016 06:04:50 GMT

Hi avinashelite,

May be a typo, should be STAR is *; instead of START is *;

I tested this script. But it doesn't display 2 Link values for User ADAM.

Re: Section Access Help

avinashelite — Wed, 13 Apr 2016 06:44:26 GMT

Thanks settu_periasamy‌ its a type error from my end

Re: Section Access Help

avinashelite — Wed, 13 Apr 2016 07:06:36 GMT

settu_periasamy‌

If * is not giving the right results try with the blank that should

something like

Section Access;

LOAD * Inline [

ACCESS, USERID, PASSWORD, LINK

ADMIN, ADAM, ADAM,

USER, PETER, PETER, WALLMART

];

Section Application;

Provider:

LOAD * Inline [

LINK

JCPENNEY

WALLMART ];

Re: Section Access Help

Colin-Albert — Wed, 13 Apr 2016 07:12:40 GMT

The star in section access means "all values listed in the section access table" not "all values in the data".

Have a look here for some examples on using section accessQlikView Section Access Examples

Re: Section Access Help

Peter_Cammaert — Wed, 13 Apr 2016 07:44:15 GMT

The star character in a link field in the Section Access table means: all values that appear in this field in the Section Access table only. NOT all values that appear in identically named fields in your entire data model.

There is no real wildcard-like "every value" concept in the associative data model. You'll have to create it yourself by entering an artificial value in this SA field (like "ALL") and mapping this value to all loaded field values by way of a new Section Application table.

Peter

Re: Section Access Help

Peter_Cammaert — Wed, 13 Apr 2016 07:46:50 GMT

Note that leaving the link field blank will only lead to showing all values for users with ACCESS=ADMIN (developers) in QV Desktop or QVB.exe. NOT in the AccessPoint where everyone is a USER anyway.