Row Level Security using filters in data foundations

[phellis]

I want to be able to implement Row Level Security using filters in data foundations.

So far I've set up the filter

not ({field1}) startswith "AAA")

So far so good.

the issue I'm having is trying to apply it to the correct users in the Edit Rights screen.

Basically I want to apply this filter to Everyone with the exception of a couple of users. So I apply the filter to Everyone and then explicitly include the other users and don't apply the filter.
However because these members are part of everyone then the filter is applied!!

How do I get around this without including everybody else?

Is there another way I can set up the filter to achieve this?

 

[lbass]

The selection logic would be:

{table.user} in ["user1","user2","user3"] or
not ({field1}) startswith "AAA")

-LB

 

[phellis]

I'd workde out that I could use this logic using either checking the CurrentCEUserName or by adding the users to the "Full Data Access" filter.

However doing either of these in the Data Foundation is causing the report to hang. So I've currently moved the logic into the report itself.