Skip to Main Content
Spotfire Ideas Portal
ADD A NEW IDEA

Data Access

Showing 447

add new datatable based on cross table in the current analysis

Customer would like to add new datatable based on cross table in the current analysis. Using pivot might be able to accomplish this but data source based on cross table is much easier to use. Thanks.
almost 4 years ago in Spotfire / Data Access 0 Future Consideration

Fully Editable Data Tables

One is able to go through a wide variety of steps to build a data table. These include: choosing data sources, insert rows, columns, transformations, adding source of file column (during insert rows) etc etc... They should all be editable! Sometim...
over 7 years ago in Spotfire / Data Access 0 Future Consideration

union multiple text files as one datatable, searh files by wildcard , extension,etc

Many customers have data exported from devices , these data are stored in text files with different date, time, etc and all have the same column structure. Customers want to union all these text files as one datatable by specify folder, or search ...
almost 4 years ago in Spotfire / Data Access 1 Future Consideration

Ability to output parameter value as-is without single or double quotes

Check the following use cases of that scenario: Very often template developers need ability to add custom-built expressions to queries in FROM, WHERE and ORDER BY parts. Multi-tenancy for templates: one set of template/IL/DS can be used for diff...
over 7 years ago in Spotfire / Data Access 1 Future Consideration

Import data from internet

It would be great if Spotfire could import a data table for the internet.; functionality that is similar to what is possible in Microsoft Excel or Power BI
over 7 years ago in Spotfire / Data Access 0 Future Consideration

Connector for Apache Kylin

Spotfire should provide better support for Apache Kylin: http://kylin.apache.org/ At the moment, only a native ODBC connection is possible, where "keep data external" is not an option. As Kylin is a SQL based big data caching engine, "import data"...
almost 8 years ago in Spotfire / Data Access 0 Future Consideration

Import Named Ranges from MS Excel

Importing a Named Range can facilitate easier and repeatable linkage between Excel and Spotfire when the page format in Excel is a report style or contains other information other than a data table of rows and columns.
almost 4 years ago in Spotfire / Data Access 0 Future Consideration

Information Designer should be able to create ROLAP models

In IBM Cognos Framework Manager, it is possible to design ROLAP models that behave like a cube to the end user. With the introduction of columnar databases like DB2 BLU or Cloudera Impala, the speed is there to support on request aggregations. The...
about 8 years ago in Spotfire / Data Access / Information Services 0 Future Consideration

Display a more user-friendly message when error is encountered during stored procedure execution

We used stored procedures to pass data to Spotfire. This should alleviate heavy data access from our server and to isolate the tables from our users. However, when error is encountered using this approach Spotfire returns a series of cryptic error...
about 8 years ago in Spotfire / Data Access 1 Future Consideration

Information Designer window backend and elements column no and sorting

In information designer we want that developer can see more number of column while creating column or joins ,currently its limited to 3 items only.Also there should be an option of keeping it in back end as floated windows so that user can switch ...
about 8 years ago in Spotfire / Data Access / Information Services 0 Future Consideration