Improving export to Excel performance

[Former Member]

Does anyone have any tips on improving excel performance when exporting a webi report? I don't want to get into discussions on why users are trying to export larger files (in excess of 6MB); I am just looking for suggestions.

When a user runs the export, not only does it take a long time, but there is simply no notification that the export is even processing or if it stopped, etc.

In previous tools, the user could run the same query and it would run and export very quickly, but in BO it could take upwards of 10min or [much] more.

Any ideas? We are on BO 4.0 SP 7 Patch 7 currently, with a planned upgrade to BO 4.1 SP4 over the summer.  Maybe this is no longer an issue with 4.1?

Thanks,

Missy

[MinoriOno]

Hi All,

My customer has the same issue on BI 4.2 SP02 patch3.

She raised an incident and got the answer, saying “It is as designed” from SAP support.

The customer posted a request to “Idea Place”.

https://ideas.sap.com/D35540

If you are facing the same issue, checking and voting the post would be appreciated.

Thanks,

Minori