Skip to Content
Jun 21, 2012 at 06:45 PM

Analysis Excel 2010 - Size limit of resultset exceeded


Hi, I have recreated the equivalent of a very slow SAP Infoset query in HANA using an Analytical View. I have started testing with small result sets in both SAP and HANA, then compare the runtimes and record count. Things have been great however I am now up to about 250,000 records in SAP which takes about 2.5 hours to run. When I run in HANA with this many records, using Analyzer for Excel 2010 I am getting the error 'size limit of resultset exceeded'.

1) I thought the limit for excel was now a million records?

2) When I take the SAP spool file and save it as a spreadsheet I can successfully open it with all 250,000 records. So why can't I display that many records via HANA and Analyzer for Excel?