Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 442

Add filter to the join interface to limit the rows of one of the column elements in the join table

I recently wanted to join two tables via information links. However, what I really needed was a subset of the rows that existed in the data table. Joining the entire data table created a resulting table that was too large to be practical and did n...
about 6 years ago in Spotfire / Data Access / Information Services 0 Future Consideration

Ability to have a base Info Link and that can be easily replaced and then others would automatically update

Hi, I often have one information link that is the full data set and others that are a 'Save as" version with some filter applied. It would be great to be able to update the base information link, and have the "daughter info links" update too. Also...
about 6 years ago in Spotfire / Information Services 0 Future Consideration

Add supported functions for in-db connections to Redshift

The supported functions for in-db connections to Redshift (https://docs.tibco.com/pub/sfire-analyst/7.12.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/connectors/amazon-redshift/redshift_supported_functions.htm) are insufficient to perform any use...
about 6 years ago in Spotfire / Data Access 0 Future Consideration

a wizard to convert an SQL-based data table to an infolink and datasource.

we have a nr of data tables based on a SQL query. It would be great if there was a wizard to convert such an SQL-based data table to an infolink and datasource. We develop often 1:1 on the database, and once the analysis is good enough we go throu...
over 6 years ago in Spotfire / Information Services 1 Future Consideration

Stop adding new empty row or semicolon in UI when editing fields

Trim ending empty rows and/or semicolon from Connection Initializer, Opens Session Command and Close session command. And, stop automatically adding any new empty row or semicolon in UI when editing any of the fields.
over 6 years ago in Spotfire / Data Access / Information Services 0 Future Consideration

Disable default runtime-query-validation in Information Services

TIBCO should disable runtime-query-validation for Information Services as the default configuration. The Information Modeler and the Report Developer wants the system to be configured for performance and visibility for issues, when querying data ...
over 6 years ago in Spotfire / Data Access / Information Services 0 Future Consideration

Post-process a data table after it is loaded

I have the need to post-process a data table after it is loaded, automatically without clicking a button. My scenario is : - spotfire file is loaded and the data is retrieved from various databases - once loaded I need to post-process data as doin...
over 6 years ago in Spotfire / Data Access 1 Future Consideration

Ability to union table components

The information designer allows you to union two data sources, say two SQL views, but you can only do this if the views are the same size, which is a huge limitation. For example, I have two tables -- Header 1 and Header 2. One as 100 columns and ...
over 6 years ago in Spotfire / Information Services 1 Future Consideration

Change Data Type Transformation holds change for when the column is already that type

I am loading data tables from excel, where sometimes the columns are real, and sometimes they are integers. I change the data type so that they are always real with a transformation. If the Q01 column is real when I add the transformation, it does...
over 6 years ago in Spotfire / Data Access 0 Future Consideration

Monitoring Data Source connections (Spotfire Analyst) for Failure

Monitoring of data source connections in Spotfire Analyst is critical to the functioning of associated Spotfire reports. If one/few connections are not working due to database outage, then it will be useful to immediately notify End users that rep...
almost 7 years ago in Spotfire / Data Access 2 Future Consideration