Forum Discussion

SSirozza's avatar
SSirozza
Frequent Visitor
2 years ago

RLS overriding DAX

Hi Team, I have this issue that I'm trying to resolve for a month now but so far no luck. Hoping you will be able to crack it. My data model consists of the following: 1. Dimension table: "HRMS Co...
tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
2 years ago

Hi SSirozza 
Can you provide some screenshots of the data model. What security roles have you created?

SSirozza's avatar
SSirozza
Frequent Visitor
2 years ago

Hi tamerj1 - thanks for your reply.

Below is the screenshot of the model (some other dimensions are there but irrelevant at this stage).

With the higlighter I have higlithed one to many relationship and the field. 

The red circle is the field that should be included in the OR for the Mobility Table.

 

As for the security roles, there are literally only 2 in the "HRMS Cost Center - Company - Division" dimension table:

1. Role 1 is Human Resources user where dimension table is [Division] = HR

2. Role 2 is Finance user where dimension table is [Division] = Finance.

 

Role 1 and role 2 need to see the matching rows in Fact Tables.

For Headcount and Separations fact tables this is already achieved, but currently the mobility table is "sliced" on old cost center only, while the expected outcome is old OR new cost center, wherever "Finance" is found.