Forum Discussion
Dynamic RLS hierachy Across Different Columns of a dim table
What have you tried and where are you stuck?
I am trying to implementate a RLS dynamicallly for a Dimension organisation. however i can't find ways to link the 3 column with my bridge table as the value i need to link are in 3 different table
Apply your RLS rules to all three dimension tables. Let the data model do the rest of the work.
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
I am trying to implementate a RLS dynamicallly for a Dimension organisation. however i can't find ways to link the 3 column with my bridge table as the value i need to link are in 3 different table