Forum Discussion

qmartiny's avatar
qmartiny
Helper III
4 years ago
Solved

RLS for star schema model

Hello lovely people

 

I need to create a RLS at the [_MAL] table level to restrict the access at a regional level.

I cannot use the standard RLS approach to create a filter in the [_MAL] like [REGION] = "AAA"

 

And I cannot use the cross filter check approach since I have a star schema with multiple bi directional relationships.

 

I would like to avoid changing the model. How would you create a RLS for this schema?

 

Thanks a lot

Quentin

 

 

2 Replies

    • qmartiny's avatar
      qmartiny
      Helper III

      That was easy.. I don't know why I did not think of this 

       

      Thank you!!