What’s new in Spotfire

Latest advancements to help you uncover insights for faster decision-making

11 / 2017

Search and zoom in Map Charts

Search for a location on the map and quickly zoom in. Spotfire suggests locations as you type.

Conditional text color in cross tables and tables

Now you can color the text in cross tables and tables when certain conditions are met, as an alternative to coloring the cell background.

Subtotals in cross tables and tables

Configure cross tables to calculate sub- and grand totals on the values displayed in the cells, as an option to calculating using underlying row level data, for example, when you want to visualize the sum of the category absolute values.

Replace data source from Source View

Now you can easily replace any data source from source view without compromising the data wrangling and data mashup you have done. This helps when you have developed the work in non-production environment and want to switch to production with one-click data source replacement.

Edit relational data connection data sources from Source View

Previously, Spotfire users had source view access to change data connection configurations like adding and removing tables and columns, adding or modifying custom queries, modifying prompts, and changing column names and other settings.

With this release, it is just as easy to make changes to the data source used by the data connection. The data source holds information regarding source IP, authentication method, time-outs and database, which are all easy to modify now.

For example, it's now easier than ever to move from a test database to a production database. If different table names are used in the databases, Spotfire highlights these differences and makes it easy to select the corresponding table.

Just click on the settings button on the data source node to edit the data connection.

Edit replace value transformations from Source View

Now you can edit replaced values in an analysis without creating additional transformation steps, so you can go back and modify previously added replacement operations if they are no longer applicable.

By editing already created operations, you can make the analysis cleaner by avoiding transformations that replace the same value over time.

SAP BW connectivity using New SAP BAPI API

The SAP BW connector now has the option to query SAP BW using the native SAP BAPI API integration without going through the ODBO API.

Not only does it provide better performance and more detailed messages from SAP BW, but also a better user experience, and it allow us to develop new features over time.

We have therefore decided to deprecate support for the ODBO API in a future Spotfire release. Both APIs will be available for a period of time so you can upgrade at your own pace.

Also available when administrators enable the SAP BW's BAPI API:

  • Load more than one million SAP BW data cells. Now connect to BEx queries representing more data, and implement more use cases.
  • Increase the default 10 minute timeout so you can import and analyze larger data volumes without timing out (also for the previous ODBO API).

Enhanced support for SAP HANA functions

Spotfire's SAP HANA connector now supports additional functions. These new functions are found in Spotfire's Custom Expressions UI: Median, Stddev_Pop, Stddev_Samp, Var_Pop, Var_Samp, Bitcount, Months_Between and Years_Between. Details for how to use these functions are documented by SAP and are subject to change over time.

Support for Teradata 16

The Teradata connector and Information Services now support Teradata 16.

Spotfire Cloud Business Author and Consumer can load public data from Spotfire Data Catalog datamarts

Now you can load data directly from publically available TIBCO Spotfire Data Catalogs into Spotfire Cloud Business Author and Consumer file.

Files authored in Spotfire Analyst and saved to the Spotfire Cloud Library are now available for Business Author and Consumer users, and you can refresh data from individual sources in the source view of Spotfire Business Author.

Enhancements in Spotfire Server

We have three new features for scheduling and routing to help administrators more easily manage rules and uncached files:

  • Prevent users from opening files that are not cached by scheduled updates and take too long to load. Learn more here.
  • Recover rules that have been auto-disabled. Now, if a deleted file is imported back to its previous location, any associated routing rules can be re-enabled by updating a setting in the server configuration file, enable-recovered-rules-automatically. Learn more here.
  • Copy routing rules and schedules from one site to another. Learn more here.

Support for new thrift transport modes in Apache Spark SQL

Spotfire's connector for Apache Spark SQL now supports the thrift transport modes Binary, SASL and HTTP. TLS security settings are on by default for new connections, making it faster to configure data connections securely, e.g., to Databricks data sources.

Add transformation to data source

In certain situations, attaching transformations to data sources can dramatically reduce the size of the analysis file as well as the loading times, based on the fact that Spotfire doesn't save the original data in the analysis file, only the transformed result.

For example, adding a pivot data transformation to the data source only stores the pivoted result table and discards the 200M original rows.

Introducing TERR-as-a-Service

TIBCO Cloud Spotfire users can now use the full power of TERR, TIBCO Enterprise Runtime Engine for R to build and deploy R functions, models and forecasts quickly and easily. Use open source R and integrate and deploy R code without the need to rewrite code. Get started with our library of over 600 CRAN packages, and share your predictive dashboards and apps easily with Business Author and Consumer uses.

08 / 2017

Rotate Markers to Indicate Direction

Rotate markers on Map Charts and Scatter Plots defined by values in a column or custom expression. Orientation of the markers can be configured to visualize directional data such as the wind’s direction or a ship’s heading.

Quick Auto-zoom in Map Charts

Save time customizing your analysis by enabling or disabling auto-zoom directly from the Map Chart contextual menu.

Enhanced Exporting to PDF

Spotfire 7.10 brings a complete overhaul of the Export to PDF feature. Not only will exported visualizations retain the visual theme of the dashboard, but they will be of higher graphical quality. In addition, the export dialog now has a preview to ensure best results. That's not all — there is now a relative scaling option that allows you to adjust the text in your visualizations to best fit your PDF page.

Scroll in Cross Table Hierarchy

When working with large Cross Tables it is now possible to scroll in the hierarchy as well as through the values. There are now three options for configuring scrolling in Cross Tables:

  • Freeze row headers is the old behavior, which keeps the row header frozen and lets the user scroll only among the column values.
  • Scroll row headers means that the cross table will always scroll through both row headers and column values.
  • Adjust automatically is the new default where the cross table will switch automatically between the two above options dependent on the width of the row headers relative to the width of the whole cross table.

API Access to Data Wrangling

The source view introduced in Spotfire 7.6 and all of the data wrangling features added since are now available via the Spotfire API. This allows for new ways of building analytics applications or adapting them on the fly. For example, with API control over the Add Columns operation, you can programmatically edit how data is blended and instantly see the results in the analysis.

Improved Debugging for R Data Functions

When developing and debugging a R data function in Spotfire, you now have the option of sending text output from the data function to the notifications in the lower left of the Spotfire window. By clicking on the notification, you can view the text. Thus, you can use this in order to write debug information as the data function executes.

Enhanced SAP BW Connectivity

You asked, and our engineers answered. The most requested SAP BW integration feature now makes it possible to automatically connect SAP BW BEx query variables to Spotfire prompts. Furthermore, you can now connect Spotfire to your cluster of SAP BW systems via the SAP Message Server load balancer.

Enhanced SAP HANA Connectivity

Spotfire's SAP HANA integration now supports Kerberos authentication in combination with SAP SSO 3.0 in all clients and servers. This enables users analyzing SAP HANA data access without entering their credentials. It also provides a central location for users and roles administration for SAP HANA administrators.

Improved Upgrade Process

You can now upgrade the node manager from the administration UI. Also, this upgrade is now part of the rollback process in case there is an issue or error with the upgrade.

1-Step Deployment of Package Updates

With one click, you can now up update, rollback, or delete your deployment packages.

Configurable Essbase Measure Dimension

Connecting to Oracle Essbase cube just got easier. Now, if your Oracle Essbase cube does not have a dimension tagged as the accounts dimension, you are able to specify which dimension contains the measures.

Pagination for Viewing Scheduled Updates

The Scheduling & Routing page now has pagination. By default, you will see 100 scheduled updates and routing rules, but you also have the option to switch the view to 50 or 150 items per page.

Performance Improvements

In response to requests from the Spotfire user community, we have greatly improved performance when filtering in external data sources.This applies for both filters in the filter panel and in text boxes.

05 / 2017

Edit Data Transformations

Spotfire 7.9 adds what has been one of the most anticipated new time-saving features, the ability to edit your data transformations. You can adapt to changes in data sources or tweak new transformations without having to start from scratch.

Data Preparation Indicators

Now, whenever a data preparation step has encountered a problem in the data source view, Spotfire will notify you with one of several severity-ranked indicators. The indicators enable quick troubleshooting of data transformations, and when paired with the new edit transformation feature, drastically reduce your time to analysis.

Load more Data from Salesforce

The native Salesforce.com connector for Spotfire is now able to load more data, such as the Case Table, which often keeps millions of records.

Improved Kerberos Integration

Spotfire Information Services now supports constrained Kerberos delegation in combination with compatible JDBC drivers.

Spotfire Cloud Data Access

Data from Amazon Redshift, Azure SQL, and OData can now be viewed in Spotfire Cloud Business Author and Consumer.

Inline Data Cleaning

Issues in your data are most often found once you start visualizing it, so why not fix them right then and there? Spotfire now has new “replace value” and “replace all occurrences” features for easily cleaning up erroneous data values in table charts and the details-on-demand panel.

Advanced Analytics

In Spotfire 7.9  99% of packages on CRAN―almost 10,000 community packages―can be loaded into the built-in R engine. We’ve also made significant improvements to the engine’s performance and to ease of use for creating graphics.

Connectors and Live Query Tables

Microsoft Azure HDInsight, APACHE KNOX, SAP SSO, and Google Analytics Web Authentication are all now supported.

Location Analytics Update

You can now right-click anywhere on a map and get geographic coordinates (latitude and longitude) for a location. Nautical miles have also been added as a unit of measurement in addition to the existing imperial and metric units when using radius and rectangle selections.

New Data Source Versions

Analysis Services 2016; PostgreSQL 9.5 and 9.6; MySQL 5.7; SAP BW 7.5; and Apache Spark SQL 2.0 are now supported.

01 / 2017

Smart Recommendations for Adding Rows

Spotfire now automatically detects and recommends if data you add to an analysis should be added as rows to existing data.

KPI Charts API

The KPI chart API allows authors and developers to automatically configure KPI Charts from IronPython scripts or custom tools. This enables creating more user friendly and powerful visual analytics applications for end users.

Configurable in-db table visualization row limit

Administrators can now configure a system wide upper limit for the number of rows possible to visualize in a table visualization based on an in-database data table. The configuration is made in Spotfire Analyst Administration Manager, on the Preferences tab, under Data Import Preferences.

Federated Authentication: OpenID

Spotfire Server now supports the use of OpenID Connect as a method of authentication.

Enable Data On-Demand in Spotfire Cloud Analyst

Your analysis can benefit from on-demand loading when you have access to massive amounts of data, but you only need to work with some parts of the data at a time. When setting up an on-demand data table you can specify conditions based on one or more other data tables to control what to load.

Support for WMS 1.3.0

The map chart now supports Web Map Service (WMS) 1.3.0 in addition to the previously existing 1.1.0 and 1.1.1 support.

Specify proportions in LayoutDefinition AP

Getting a nice layout when automating dashboard creation has often been cumbersome. With the new capabilities in the LayoutDefinition API, developers can specify proportions (vertically or horizontally) to get full control over the layout of the visualizations on a page, similar to what is possible to configure from the user interface.

Connectors: SQL Server 2016, Azure SQL and Azure SQL Data Warehouse support.

Spotfire's connector for SQL Server now supports SQL Server 2016, Azure SQL and Azure SQL Data Warehouse.

Spotfire Server can use Microsoft SQL Server

The Spotfire Server needs a database to store its own data. As of Spotfire 7.8, Microsoft SQL Server 2016 can be used as an option.

10 / 2016

Sparklines on KPIs

Add context to your KPI charts with Sparklines that visualize the trend over time.

TERR Aggregations

Use TERR to define your own Spotfire aggregations in R.

Web Authoring of KPI Charts

Business Author users can now create and configure KPI chart visualizations using a simple drag and drop method.

"Export Data To File" added to Automation Services, and "Send Email" improved

A new task, Export Data to File, has been added in Automation Services, and new features have been added to the Send Email task.

Improved Map Chart Zoom Visibility

When using the Zoom Visibility property to create geographic drill-downs, map layers interactivity switches automatically as you zoom-in/out the map.

Google Analytics and Salesforce Connections

Create and edit connections to Google Analytics and Salesforce in the web authoring client.

Control the layout for different screen sizes

Create great mobile Spotfire dashboards and reports that scale with your screen.

SAP BW Connection Improvements

Improved BEX variable handling and ability to configure how the SAP BW characteristics are displayed in the Spotfire UI.

Developer APIs

Create custom panels in the web client to visualize contextual information, adding controls or other domain specific functionality to Spotfire.

Improvements to Tables and Cross-Tables

Create more compact and better looking tables and cross tables, with better control over cell width, alignment, and absolute sorting.

Easier Administration

Easily monitor and maintain your scheduled updates and your web player resources from new web UIs. Easier deployment of data connectors to Spotfire Analyst users.

Multilayers Map Chart via Spotfire Business Author

Create map charts with multiple layers of data. Use your favorite map background. Visualize map layers from GIS.

Self-Service Data Lake and Text Analytics

Attivio has the ability to identify, integrate, unify and provision virtually any type and amount of structured data and unstructured content. Spotfire's new self-service connector to Attivio makes it easy for business users to connect to, search and analyze the result in Spotfire.

Web Panel API

Leverage the new Web Panel API to create custom panels in the web client to visualize contextual information.

05 / 2016

KPI Charts Any Time, Any Where

See real-time business performance metrics at a glance—on your phone, your tablet, or your computer.

Support for Tile Map Services (TMS) on Map Charts

New support for Tile Map Services (TMS) means you can more easily use the base map background of your choice.

Configure Map Chart Auto-zoom via Spotfire Business Author

Set a map chart to automatically zoom-in to the filtered data.

Unpivot from Data Panel

Spotfire data panel now has a built-in unpivot option on the right-click menu.

Spotfire Business Author Connector for Salesforce.com

Business Author users can now automatically connect to Salesforce.com.

New Data Connectors for MongoDB and Apache Cassandra

Import data from two major in-memory NoSQL databases without any external applications or platforms.

More Control Over Cross Tables

Change individual column width, text alignment, and orientation to make your tables more compact and readable.

Radius Selection on Map Charts

In addition to rectangle and lasso selection tools, the new radius tool lets you mark data around a location.

View, Configure, Refresh Data Sources

From both the source view and the library, you can now select between "Always New Data,” "Stored Data,” and "New Data When Possible.”

Google Analytics Data Connector

Spotfire® Business Author and Spotfire® Analyst can incorporate Google Analytics data with ease and speed.

More Connection Options for these Key Sources

Amazon Redshift, Hortonworks, Oracle and Oracle MySQL, Pivotal Greenplum, Pivotal HAWQ, and Postgres SQL.

03 / 2016

New Architecture, Better Control and User Experience

Control how resources are scaled, isolated, and used with rules that route users to specific resources.

Higher Productivity with Threaded Conversations

A chat box within the visualization helps groups focus, bring insights, and make decisions.

Waterfall Charts Show the Forest and the Trees

Quickly see how parts of the whole negatively or positively affect the total.

Improved Data Panel with Instant Data Profiles

An improved data panel let's you get a quick overview of your data and easily make adjustments.

Apache Spark Analytics

Spotfire has certified connectivity with Apache Spark so you can perform large-scale data analysis.

SAP HANA Analytics

Spotfire now has an improved integration with SAP HANA Analytics. Expanded support for SAP HANA Information Views and Attribute Views promotes a greater navigability of the data, in addition to overall performance enhancements when handling SAP HANA Analytics.

Split Columns Dialog Box

In a few clicks you can split a column with multiple values in its cells into columns for each of the distinct values.

Quickly Refresh Linked Data

Press Refresh while in a Spotfire Cloud analysis for the latest updates to the data.

TIBCO Enterprise Runtime for R Supports 5,300+ R Packages

You can use much of the Comprehensive R Archive Network (CRAN) with Spotfire out-of-the-box.

Easier to Find Data Connectors

ODBC Drivers for TIBCO Spotfire Analyst are now available directly in the 'My Downloads' section of Spotfire Cloud.

Reduced System Requirements

he Spotfire Analyst client now runs on 32-bit operating systems and no longer requires Internet Explorer 10+.

Better Explanations through Annotations

Comments that can explain and draw attention to key points in your visualization.

Synchronization Across Multiple Windows

Interacting with a visualization in one browser window automatically updates the other windows.

Box Plots Have More Options

Deliver more information with horizontal lines on whiskers, single diamonds for median values, or dotted lines for averages.

Inline Data Cleansing

Change the data order and categorization, create new columns, fill in empty values, and format on the fly.

Salesforce.com Analytics

The new driver makes it easy to browse your Salesforce data and answer questions fast.

Data Table Source View Shows Process and Results

View data table sources and what’s been done to the data, and preview the results from each of the intermediate steps.

Streamlined Filter Selection

The streamlined filter selector allows quick selection and deselection of filters to get the view you need faster.

Months and Days Treated as Time, Not Text

Column names and data are sorted in time sequence (not alphabetically), with local culture settings upheld.

Data Connector Improvements

Improvements to connectors for Microsoft SQL Server Analysis Services, SAP BW.

API for Embedding Visualizations in a Webpage

Embed Spotfire visualizations in HTML for an interactive data analysis experience on the web.