KH H Posted March 30, 2023 Share Posted March 30, 2023 Hello,I have two tablesAand BI have transformed table B by unpivoting itnow I want to creat the relationship between the two tables.but I get a message that I can’t create the relation “The relation couldn not be created since it leads to cyclic dependences”i need to create the relationship between the two tablesI have a table from table Aand a pie chart from table B i want by clicking on value from the tablethe pie chart to be filtered with data from the unpivted table Link to comment Share on other sites More sharing options...
Fredrik Rosell Posted March 31, 2023 Share Posted March 31, 2023 Hello,Spotfire does not support cyclic dependencies so you need to find a way to change your analysis to avoid that.First (quoting one of the knowledge base articles mentioned below), just to describe what this is:"A cyclical dependency is a relation (data table relationship, insert rows, insert columns, etc) between multiple data tables that which are defined based on each other in such a way to create a loop. When attempting to add a relationship between tables in the TIBCO Spotfire installed client which would lead to this cyclical dependency, you will be prompted with a warning "The relation could not be created since it leads to cyclic dependencies between data table."Here are two support knowledge base articles that describe various ways you can deal with this, so please try to redesign your analysis based on the techniques mentioned there:https://support.tibco.com/s/article/Warning-message-in-TIBCO-Spotfire-client-The-relation-could-not-be-created-since-it-leads-to-cyclic-dependencies-between-data-tableshttps://support.tibco.com/s/article/How-to-avoid-cyclic-dependencies-between-data-tables Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now