Forum Discussion
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 hierachy restriction as follow
Besides, an employee/manager can have access to a top level of the hierachy and have his staff accessing only few part of a level (including the belonging part of the below level). => hope this illustraction is clear enough.
However, I am having to deal with the listed below tables:
- Bridge Table
- Dimestion table
I now need to find a way to relate those two table based on the criteria that an user can:
- have access to only the "site" column values
- Or to the "sector" column and the below values of "site" Column
- Or to the "DR" column and the below values of "sector" Column, then "site" Column
- Or to the "Segment" column and the below values of "DR" Column, then "sector" Column and "site" Column of that "segment"
Thank you in advance for your guidance on this case
7 Replies
- lbendlin
Super User
user can: have access to only the "site" column values Or to the "sector" column and the below values of "site" Column Or to the "DR" column and the below values of "sector" Column, then "site" Column Or to the "Segment" column and the below values of "DR" Column, then "sector" Column and "site" Column of that "segment"Take these rules and implement them in the DAX rule for that dimension. Return TRUE if all conditions are met, FALSE otherwise. use the " || " or operator.
Can someone please help me on this issue
- lbendlin
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
