Section Access based on Fields in a Dimension

[Bird_za]

Hi there I need to allocate section access to specific clients based on certain fields in a dimension and could use some help,

Dimension:  Personnel Area 

fields :   PlaceA, PlaceB PlaceC PlaceD

user: Birdy@email.co.za  needs to have access to only data related to fields PlaceA and PlaceB

user: Chavo@email.co.za  needs to have access to only data related to fields PlaceC  and PlaceD

is it possible to use section access to achieve this?

thanks, bird.

[BrunPierre · Accepted solution]

As follows

SECTION ACCESS;
LOAD * INLINE [
    ACCESS, NTNAME, OMITGROUP
    ADMIN DOMAIN\QV_DEVELOPER, *
    USER, DOMAIN\BIRDY@EMAIL.CO.ZA, GROUP2
    USER, DOMAIN\CHAVO@EMAIL.CO.ZA, GROUP1
    ];
    
    LOAD * INLINE [
    OMITGROUP, OMIT
    GROUP1, PLACEA 
    GROUP1, PLACEB
    GROUP2, PLACEC  
    GROUP2, PLACED  
];

SECTION APPLICATION;
FIELDS:
LOAD * INLINE [
    PLACEA, PLACEB, PLACEC, PLACED
    VALUEA, VALUEB, VALUEC, VALUED
];

[Bird_za]

thanks for the quick response, I am curious as to what the 3rd inline table achieves if you don't mind explaining

[BrunPierre]

In Section Application, field names must all be uppercase. It is automatically rendered as uppercase in Section Access.

[Bird_za]

So what are those VALUE fields?

[BrunPierre]

The 3rd inline should the part of your script loading the app data. With all the string values of the OMIT fields (PlaceA, PlaceB, PlaceC, PlaceD) in your data model converted to uppercases.   

Hope this clarifies things.