Hi, i am facing a issue in report type is multilevel pivot?

Sachin65
Tera Expert

‎11-05-2018 02:00 AM

problem is when i am executing a report its showing " Cannot generate the report. This report contains too much data to visualize. Add filter conditions to reduce the amount of data "  

but its is only 40k records, before this report working properly, now it is not working.  

 

0 Helpfuls
  • 1,542 Views
2 REPLIES 2

Dubz
Mega Sage

‎11-05-2018 02:21 AM

As far as i'm aware, ServiceNow doesn't support the scheduling or export of multi-level reports. 40k records on a multi-level pivot can have a huge number of data points. You'll need to either change the report or export the raw data to excel and make your pivot table there.

0 Helpfuls

kriangkrai
Tera Guru

‎01-25-2024 05:39 AM

Hi @Sachin65 

 

I got the same error and found below KB about this.

 

KB0825681 

There is limit of 10,000 data points that can be shown on a multi-level pivot report before the error message is triggered. This limit is hard coded and cannot be changed in the system properties table.

 

Regards,

Oat

 

0 Helpfuls