Section Access problem

[giakoum]

Hi all.

I have posted the same issue before, but have not solved it yet.

I need user 2 (password: 1) to access ONLY the following :

BU1, EUROPE, NW EUROPE, 1

BU1, EUROPE, S EUROPE, 2

BU2, EUROPE, NW EUROPE, 11

instead, he can access the following record as well :

BU2, EUROPE, S EUROPE, 12

This is because for BU1 he has already access to both NW EUROPE & S EUROPE, so he gets it for BU2 as well.

Is there a workaround here?

ADMIN username : 1

ADMIN password : 1

See attached file.

Thank you

Ioannis

[rajni_batra]

PFA

[giakoum]

Thank you rajni, but you have included value in the section access, which is not possible. Value is a fact, not a dimension, we cannot exclude records based on that. It changes in every reload.

[flipside · Accepted solution]

Hi Ioannis,

Your security isn't granular enough, you need to factor in the combination of PF and AREA and add that to the security table.  One way is to change the security table to ...

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, BU, REGION, AREA, BU_AREA

    ADMIN, 1, 1,,,,

    USER, 2, 1,BU1,EUROPE,NW EUROPE,BU1/NW EUROPE

    USER, 2, 1,BU1,EUROPE,S EUROPE,BU1/S EUROPE

    USER, 2, 1,BU2,EUROPE,NW EUROPE,BU2/NW EUROPE

    ];

... and then create the BU_AREA field in your data

data:

LOAD *, PF & '/' & AREA AS BU_AREA INLINE [

    PF, REGION, AREA, VALUE

flipside

PS Looking at it again, you can probably change the security table like this ...

LOAD *, BU & '/' & AREA AS BU_AREA INLINE [

    ACCESS, USERID, PASSWORD, BU, REGION, AREA

    ADMIN, 1, 1,,,

    USER, 2, 1,BU1,EUROPE,NW EUROPE

    USER, 2, 1,BU1,EUROPE,S EUROPE

    USER, 2, 1,BU2,EUROPE,NW EUROPE

    ];

... but I haven't tested this yet.

[giakoum]

Excellent idea, thank you!