The Table visualization and Details-on-Demand (D-o-D) visualization cannot display more than 10000 rows from an in-database (in-db) data source in Spotfire

The Table visualization and Details-on-Demand (D-o-D) visualization cannot display more than 10000 rows from an in-database (in-db) data source in Spotfire

book

Article ID: KB0070434

calendar_today

Updated On:

Products Versions
Spotfire Analyst All

Description

The Table and Details on Demand visualization is displaying only up to 10,000 rows of data for any kind of In-database data connection(keeping data table external).
 

Issue/Introduction

The Table visualization and Details-on-Demand (D-o-D) visualization cannot display more than 10000 rows from an in-database (in-db) data source in Spotfire

Environment

All

Resolution

For Spotfire 7.7 and older:

The Table and Details on Demand visualization can display only up to 10,000 rows of data for any kind of In-database data connection. This behavior is designed to prevent large databases from overflowing Spotfire.

For Spotfire 7.8 and later:

TIBCO Spotfire Administrator can configure the number of rows to display in a table visualization when running against In-DB data.
For it, login into Spotfire Analyst With Administrator Rights >> Tools Menu >> Administration Manager >> Preferences Tab >> Select the desired group >> Expand Application >> DataImportPrefernces >> Edit button >> TableVisualizationExternalRowLimit.