Spotfire Ideas Portal
It would nice if when adding multiple tables from a relational database there was an option to automatically create the table relations in Spotfire based on the database foreign keys. This would save a lot of time and ensure that the relations remain the same as in the database.
Thomas,
I like that idea for the star schema in idea "TS-I-5488".
The idea I had submitted here was when our company was fairly new to Spotfire and we've certainly gotten more efficient with adding tables (the new "Data Canvas" has also been a huge improvement here recently also).
But ya the idea I submitted (TS-I-5294) was dumber/simpler. I just wanted to be able to select 2 separate related tables to import from a single relational database and keep them as separate tables without import columns from one to the other, while having Spotfire go ahead and automatically create the data table "Relations" between the tables in the Spotfire document based on the foreign keys from the relational database.
Thanks for following up!
This is supported in data connection views. Would you like to be able to load for example a star schema into Spotfire then please vote and comment on this idea https://ideas.tibco.com/ideas/TS-I-5488.