Forum Discussion
TaxiDriveDax
2 years agoFrequent Visitor
Dynamic RLS hierachy Across Different Columns of a dim table
Hi All, I am hoping find help to my current issue. I have got to implement a Dynamic RLS for hierachy over multiple columns of a dimension table. The requirement consist of implementing an ...
lbendlin
2 years agoSuper User
Apply your RLS rules to all three dimension tables. Let the data model do the rest of the work.
TaxiDriveDax
2 years agoFrequent Visitor
but it's only one table which content three different columun like on the figure above for the dimension table. I now need to figure out a way to connect my bridge table with all the 3 column values(from the dimension table) combined in a column on the bridge table. In fact i have to figure out a way to match value between the brigde table and the dimension table based on the hireachy restriction