Oracle Analytics and AI

MeghaR

We are using excel template pivot functionality to develop a costing report. Oracle supports only xls excel template and this is causing issue when the number of data rows exceed 65k limit. Is there a workaround to achieve pivot functionality with filters and drill down option without using excel template.

Manu R-Oracle

Hi Megha,

This is so because Excel has a limit of 65,536 rows per worksheet. This limit is imposed by the amount of memory that Excel can allocate to a single worksheet.

Few Alternatives/workarounds could be:

1.Split the data into multiple worksheets. If you have a large amount of data, you can split it into multiple worksheets, each with no more than 65,536 rows. Then, you can create a pivot table for each worksheet.

2.See if the number of records in the output can be reduced. Re-validate the query for duplicates or see if it could be split into different reports controlled by different parameters.

Hope this helps.

Thanks

Manu