Section Access Data Level Security Problem

[lylererger]

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!

[Gysbert_Wassenaar]

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.

[maxgro]

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

[lylererger]

Friends thank's a lot )))

I wish you luck and happy times