Handling Inactive relationship with RLS

[PremsagarTCS]

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.

[v-xiaoyan-msft]

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]

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