how to link these tables with security accomplished

[ali_hijazi]

Hello I got 2 tables in qlikView

one table contains the following columns and sample data:

Brand          Store    

ADL               1

DIS               1

DIS               2

YTR               2

YTR               3

...

Now I want to get table for security with users and what each user is allowed to see

the security table contains as structure and sample data the following:

USER     Store               Brand

U1          *                         ADL

U2          1                        *

U3          *                         *

U4          2                         YTR

can someone give me the best practive for implementing the security here

[gandalfgray]

Hi Ali

Try with this:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    USER, U1, pwd

    USER, U2, pwd

    USER, U3, pwd

    USER, U4, pwd

    ADMIN, su, su

];

Section Application;

Star Is *;

Users:

LOAD * INLINE [

    USERID, Store, Brand

    U1, *, ADL

    U2, 1, *

    U3, *, *

    U4, 2, YTR

];

Star Is;

oneTable1:

LOAD * INLINE [

    Brand

    ADL

    DIS

    YTR

];

oneTable2:

LOAD * INLINE [

    Store

    1

    2

    3

];

Note that I had to use two tables in the application I could not get it to work when I had one table like this:

oneTable:

LOAD * INLINE [

    Brand, Store

    ADL, 1

    DIS, 1

    DIS, 2

    YTR, 2

    YTR, 3

];

don't know why...

hth anyway/gg

[ali_hijazi]

however to avoid synthetic keys I need that the second scenario works