Troubleshooting
Problem
When you create a Crosstab visualization that projects thousands of data points, you might encounter the following error message:
The estimated number of cells exceeds the allowable value of 100000. Apply filtering to projected sets to reduce the number of cells.
Cause
This error occurs because a size limit is now enforced on queries sent from dashboards. If a query exceeds the size limit, no data is returned, and the visualization displays the error message.
Resolving The Problem
As the error message suggests, apply filters to reduce the size of the query to get a functioning visualization.
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m500000008d6PAAQ","label":"Reporting->Dashboards"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1.7","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Was this topic helpful?
Document Information
Modified date:
01 August 2020
UID
ibm16250001