Mutiple Table Row Level Security

building semantic layer
1

I am trying to set up Row Level Security and have two tables. I want to set up the security to work as an OR function

Table1
Distributor District = U01

Or

Table2
Customer District = U01

Currently the Row level security works as an AND function.

jaimejaiv (BOB member since 2007-07-09)

2

Try combining both the conditions in one Row-Level restriction.

  1. Tools --> Manage Security --> Rows --> Add
  2. Select table1 --> Click on Where Clause button --> apply condition 1 -->
  3. Select table2 --> Click on Where Clause button --> go to the end of the line --> type in and/ or and apply condition2 --> Click ok --> ok --> check all --> ok --> save and export the universe

I hope this helps.

sunjer (BOB member since 2008-01-30)