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