topic Re: Section acces script in QlikView

Section acces script

Tue, 29 Jul 2014 13:43:20 GMT

This is my hidden script for section acces.

The user can only see the project with id 24

I want the admin to be able to see al projects, but now the admin can only see project nr 24.

What is wrong in my script?

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, PROJECT

ADMIN, ADMIN, ADMIN, *

USER, WOMMELGEM, 24, WOMMELGEM

];

Section Application;

LOAD * INLINE [

project_id, PROJECT

"24", WOMMELGEM

];

Re: Section acces script

joshabbott — Tue, 29 Jul 2014 13:48:29 GMT

All the projects should be in your list, not just 24. Maybe you could add the 'PROJECT' to the actual table and have it be only 'WOMMELGEM' for 24 or left join this table to your project table (or mapping table)

Re: Section acces script

michael_maeuser — Tue, 29 Jul 2014 13:59:55 GMT

like josh wrote, all projcts need to be listed if you set a wildcard.

so just load all projects from your fact.qvd or whatever and concatenate them.

s.th. like that

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, PROJECT

ADMIN, ADMIN, ADMIN, *

USER, WOMMELGEM, 24, WOMMELGEM

];

concatenate

load

PROJECT

from facts.qvd;

Section Application;

LOAD * INLINE [

project_id, PROJECT

"24", WOMMELGEM

];

Re: Section acces script

tobias_klett — Tue, 29 Jul 2014 14:03:01 GMT

Hi Katleen,
your USER has PASSWORD 24 instead of PROJECT 24.

The star " * " only knows the other entries of your list. Therefore you need at least one Entry for each Project. Otherwise the star only knows 24 because it is the only project which occurs in the field.

Hope this helps
Tobias

Re: Section acces script

Wed, 30 Jul 2014 07:12:54 GMT

I tried the script below, but he can't find the id..

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, id

ADMIN, ADMIN, ADMIN, *

USER, WOMMELGEM, 24, WOMMELGEM

];

Concatenate

LOAD id as project_id

FROM

[..\2. Extraction to QVD layer\QVD\projects.qvd]

(qvd);

Section Application;

LOAD * INLINE [

project_id, id

"24", WOMMELGEM

];

Re: Section acces script

SunilChauhan — Wed, 30 Jul 2014 07:18:14 GMT

document setting -> opening->Check Intial data reduction based on section access and strict exclusion

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, PROJECT

ADMIN, ADMIN, ADMIN, *

USER, WOMMELGEM, 24, WOMMELGEM

];

concatenate

load

PROJECT

from facts.qvd;

Section Application;

LOAD * INLINE [

project_id, PROJECT

24, WOMMELGEM

];

Re: Section acces script

Wed, 30 Jul 2014 07:19:38 GMT

I checked the initial data reduction and strict exclusion already.

I tried the script below, but he can't find the id..

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, id

ADMIN, ADMIN, ADMIN, *

USER, WOMMELGEM, 24, WOMMELGEM

];

Concatenate

LOAD id as project_id

FROM

[..\2. Extraction to QVD layer\QVD\projects.qvd]

(qvd);

Section Application;

LOAD * INLINE [

project_id, id

"24", WOMMELGEM

];

Re: Section acces script

SunilChauhan — Wed, 30 Jul 2014 08:15:27 GMT

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, id

ADMIN, ADMIN, ADMIN, *

USER, WOMMELGEM, 24, WOMMELGEM

];

Concatenate

LOAD id as project_id,

FROM

[..\2. Extraction to QVD layer\QVD\projects.qvd]

(qvd);

Section Application;

LOAD * INLINE [

project_id, id

"24", WOMMELGEM

];

make sure id's values are in upper case

hope this helps

Re: Section acces script

michael_maeuser — Wed, 30 Jul 2014 08:40:11 GMT

there´s something strange, i guess. which field of your data you want to restrict? can you upload some sample data in an xls?

Re: Re: Section acces script

Wed, 30 Jul 2014 09:05:55 GMT

Sample qvd and qvw

The idea is that a certain user van only see the project with id = 24

and the admin can see all projects

Re: Re: Re: Section acces script

michael_maeuser — Wed, 30 Jul 2014 11:33:53 GMT

check this one. hope that helps.

user: ADMIN,

pw: 1

Re: Re: Section acces script

Wed, 30 Jul 2014 11:40:22 GMT

Seems to work perfect!