Forum Discussion

D_G's avatar
D_G
Frequent Visitor
1 year ago
Solved

Enterprise Data modelling and RLS best practices

Hi. I'm looking data modelling best practices for an enterprise. I have a data model with enterprise common master data tables (green), transactional tables (blue), enterprise structure table (Dim_Co...
Need Help
  • ajohnso2's avatar
    ajohnso2
    1 year ago

    You only need to create a bridge for Fact Sales > <Bridge> > Dim Warehouse enable 2 way filtering.

     

    1-2-many Fact to Bridge

    1-to-many Bridge to Dim 

     

    Your RLS will filter Dim Company which will filter Fact Sales which will filter warehouse bridge which will filter Dim Warehouse.

ajohnso2's avatar
ajohnso2
Solution Supplier
1 year ago

You only need to create a bridge for Fact Sales > <Bridge> > Dim Warehouse enable 2 way filtering.

 

1-2-many Fact to Bridge

1-to-many Bridge to Dim 

 

Your RLS will filter Dim Company which will filter Fact Sales which will filter warehouse bridge which will filter Dim Warehouse.