ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Advanced reporting error "Crosstab bucket/measure limit (100,000) exceeded"
Article ID: 111109
Clarity PPM SaaS
Clarity PPM On Premise
The report error received in Jaspersoft is:
Crosstab bucket/measure limit (100,000) exceeded
Try reducing the amount of data by following the below strategies:
- Set up a report with Start Date and End Date
- Run the report quarterly vs for all time
- Run the report with more filters to reduce the number of rows