Spotfire relationship issues - cyclic dependency

[Shravan Vijayaprasad]

I'm very new to Spotfire, so apologize if this question is super simple. I have four tables, FactTable A and Fact Table B (Both have year and quarter and region), Dimension table Time and Dimension table Region.

Now I want to create a filter on Year and Region on both Fact table A and Fact table B

I create a relationship between Fact table A and dimension table Time on Year and Quarter and I create another relationship between Fact table A and dimension table Region on region.

I tried creating the same relationships for Fact table B, but I get the cyclic dependency error. Could someone give me some ideas on how to figure this out

[Khushboo Rabadia]

Please go through below KB article on understanding and resolving cyclic dependency:

https://support.tibco.com/s/article/How-to-avoid-cyclic-dependencies-between-data-tables