SAP Fiori Elements Analytical List Page Export to Excel stops after first batch call

[Matthias_Herzog]

Hello everybody,

I have an Analytical List Page as a Fiori Elements Application where i enabled the Export to Excel Feature. But everytime when i try to export the Dataset without any kind of filtering which would approx. be around 90k Entries the export stops after the first batch and the exported Excel has only 1.6k Entries.Additionally the max amount of entries to export shows only 8k. Additionally i cant attach a listener to the beforeExcelExport Event as the Analytical List Table does not provide the Method. Pictures are attached.

Any help is really appreciated as I dont know what to look out for and there are no signs of any known issues in the documentation.

(I know that in the screenshots provided is a filter, but it does not change the result only the numbers are a little bit different)

Thanks & Best Regards

Matthias

[junwu]

did you specify that 1600?

where you get this?

Additionally the max amount of entries to export shows only 8k

[Matthias_Herzog]

Hello jun.wu5 ,

Thanks for your comment. That's the thing i did not specify the batch size nor the max count as it is seems to be not possible with the Analytical Table. It must be standard SAP calculations in the background.

Yeah, I know but when i try to count the entries from this exact OData Service in the GW with $count it shows around 90k Entries so there must be something wrong...

[Matthias_Herzog · Accepted solution]

The answer was to not forcefully sort after a Measure Attribute because this messed up the $skip and $top parameters and when $skip is greater than $top it stops.