Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Can't determine relationship between fields

I have three tables as in the following photo. Invoices.SKU joined to SKU_ID_mapping.ID SKU_ID_mapping.SKU joined to product categories.SKU.   In the past it worked but this time I am getting an ...
Need Help
lbendlin's avatar
lbendlin
Super User
2 years ago

Please try not to use bidirectional connections from a dimension to a fact table.

 

Add a measure to your visual, any measure.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi lbendlin thanks, why bidirectional connections are not a good idea? 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Let's say you have RLS on the dimension table.  With the bidirectional connection that RLS becomes ineffective.