topic Re: Section Access Data Level Security Problem in QlikView

Section Access Data Level Security Problem

lylererger — Sat, 28 Nov 2015 09:16:31 GMT

Hi friends!

Please explain to me one simple thing - why Section Access is not working?

I'm created Section Access block in hidden script with password: 1

Then I've loaded data model.

And finally I've enabled option: "Initial Data Reduction Based On Section Access" and then reloaded then Data Model.

Here example of section access table:

SECTION Access;

LOAD * Inline

[

USERID, PASSWORD, ACCESS, LOCATION

A, A, ADMIN, *

B, B, USER, *

C, C, USER, CANADA

D, D, USER, *

E, E, USER, *

] ;

SECTION Application;

When I'm logging on as USERID : A , Field LOCATION displays then value only for CANADA.

Please help!

P.S: Model in attachment.

Thanks in advance!

Re: Section Access Data Level Security Problem

Gysbert_Wassenaar — Sat, 28 Nov 2015 10:30:48 GMT

The * means all the listed values. Only CANADA is listed in the table so every user with * will only see CANADA. Remove the * for the users that should be able to see not only all the listed, but all the unlisted values too.

Re: Section Access Data Level Security Problem

maxgro — Sat, 28 Nov 2015 10:53:09 GMT

you can add a dummy user, this way

SECTION Access;

LOAD * Inline

[

USERID, PASSWORD, ACCESS, LOCATION

A, A, ADMIN, *

B, B, USER, *

C, C, USER, CANADA

D, D, USER, *

E, E, USER, *

DUMMY, DUMMY, USER, USA

DUMMY, DUMMY, USER, MEXICO

];

or concatenate a dummy user with all the distinct location from fact table

Re: Section Access Data Level Security Problem

lylererger — Sat, 28 Nov 2015 10:55:58 GMT

Friends thank's a lot )))

I wish you luck and happy times