Forum Discussion

ansa_naz's avatar
ansa_naz
Icon for Continued Contributor rankContinued Contributor
7 years ago

Measures not working when RLS is turned on - Join paths are expected to form a tree

Hi all I have the following error when RLS is turned on (this error does not show when RLS is off):   Join paths are expected to form a tree but the table has two join paths   These are th...
Need Help
ansa_naz's avatar
ansa_naz
Icon for Continued Contributor rankContinued Contributor
7 years ago

Hi Anonymous  I already have multiple fact tables. I just need to figure out a way to get the measure working without an inactive relationship being used within it. Any ideas?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

ansa_naz 

Will the measure work without changing the relationship used?

 

Otherwise, I think you need to change your model. The multiple paths are harming your functionality.

 

Specifically, unless there are very complex requirements, look into:

1. Separate entities into dimension tables and model as star schemas around a fact tables

2. Avoid bi-directional relationships  

 

Hope this helps,

Nathan