High-Cardinality Thresholds for Report Objects

Client-side thresholds for report objects are documented in the following table. These thresholds affect the designer and the classic viewer. For information about adjusting high-cardinality thresholds for the modern viewer, printing, and SAS Mobile BI, see the “Configuration Properties: SAS Mobile BI” topic in SAS Intelligence Platform: Middle-Tier Administration Guide.

Note: The second column indicates the maximum number of unique values.

Client-Side Thresholds for Report Objects
Report Object	Rows
Gauges (bullets, sliders, thermometers, dials, and speedometers)	10
Word cloud	100
Bubble plots	1,500
Bar charts (regular, targeted, dual axis, and dual axis bar-line)	3,000
Waterfall charts	3,000
Line charts (regular and dual axis line)	4,000
Geo maps (bubble, coordinate, and region)	5,000
Step plots	10,000
Time series plots (regular and dual axis)	10,000
Treemaps	25,000
Pie charts	40,000
Scatter plots	40,000
Tables (list tables and crosstabs)	40,000

Here are some key points about high-cardinality thresholds in report objects:

In general, requests that exceed a client-side report object threshold cause an error message to be displayed. An exception is that for detail data, excess rows are truncated.
Scatter plots always show detail data. List tables show details if the user selects the Show detail data check box. Bubble plots show details unless a category is assigned to the Group role.
If a data source contains more than a million records, queries are blocked for data items whose cardinality is greater than 10,000 unique items in any particular category.