Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

RLS on two different Dimension-Tables

Hi together,

 

I have the following Star-Schema with three Dimension-Tables and one Fact-Table.

I want to add a RLS Role which has a filter on two Dimension-Tables.

 

The result shows only the intersection of both filter. Is it possible to get the combination of both, so like an AND connection?

Thank you in advance!

 

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you very much for this feedback!

      So, there is no other way to use dynamic RLS? This is the standard approach to put a filter on two dimension-tables for one RLS role?

      • MFelix's avatar
        MFelix
        Super User
        4 years ago

        Hi  Anonymous ,

         

        The options I have seen all are based on similar approachs since you need to have the filtering at row level for each of the tables.