How can I apply data Reduction in an OR relation

[janbouwmans]

Hi,

I have the following problem: UserX needs access on all entries where Country=DE or where user is the SalesPerson. ( So the user needs to see his own sales and all sales in Germany)

I have tried to solve this by assigning UserX to a "DatareductionGroup" in an Excel list:

DOMAINNAME DATAREDUCTION_GROUP

UserX Demo_1

Next I have created a new list with 2 lines:

DATAREDUCTION_GROUP DATAREDUCTION_CTRY DATAREDUCTION_SALESPERSON

Demo_1 * UserX

Demo_1 DE *

I have loaded the DatareductionGroup info in one table:

Link_DATAREDUCTION:

LOAD

upper(DATAREDUCTION_GROUP) as DATAREDUCTIONGROUP

DATAREDUCTION_CTRY

as Country,

DATAREDUCTION_SALESPERSON as Salesperson

From ...

This doesn't seem to work.

My question is: Did I do something wrong? Is this at all possible? Is there another solution to apply "OR"relations in datareduction.

Thanks for any help.....

Jan