cancel
Showing results for 
Search instead for 
Did you mean: 
0

Handling Inactive relationship with RLS

Hi All,

We have a model where we connect Dimension table (with RLS) with FACT as below.

1) "Dimension Key" to "Fact Current Key" -- Active
2) "Dimension Key" to "Fact Historical Key" -- Inactive

To manage the switch of relations we use "USERELATIONSHIP" but this is not deactivating the existing relation as we use RLS.
Can you please guide appropriate alternative for this issue.

Note : We are trying to avoid duplicate dimensions for each relation.

PremsagarTCS_2-1669644740465.png

 

Status: Delivered

Hi @PremsagarTCS ,

 

USERELATIONSHIP normally inactivates an existing, active relationship, setting row-level security causes the active relationship to not become inactive.

Here is a blog that explains this very well, I hope it will help you.

Row-Level Security and inactive relationships - Quanto blog site (quanto-blog.eu)

 

Best regards.
Community Support Team_ Caitlyn

Comments
v-caitlyn-mstf
Community Support
Status changed to: Delivered

Hi @PremsagarTCS ,

 

USERELATIONSHIP normally inactivates an existing, active relationship, setting row-level security causes the active relationship to not become inactive.

Here is a blog that explains this very well, I hope it will help you.

Row-Level Security and inactive relationships - Quanto blog site (quanto-blog.eu)

 

Best regards.
Community Support Team_ Caitlyn

PremsagarTCS
Regular Visitor

Hi  Thanks for the response.

I agree in this model with RLS userelationship will not inactivate existing active relationship.
In my model i am using a calculation  group for "Current View" and "Historical view" selecting them will activate userelationship formulas.
Can you please suggest any other alternative to achieve this.

Thanks
Premsagar