Improving export to Excel performance

[#1]

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

[Former Member]

This issue isn't limited to Webi, we are experiencing this issue with AOLAP.

We went from 4.1 SP1 Patch 5 to 4.1 SP4 Patch 2.

Exporting 1.3m cells went from 30-40seconds to 8 + minutes.

Have tried, xls, xlsx, csv.  Have tried exporting only 100k cells and still took 2.5minutes.  Our environment is sized quite large with a decent amount of memory, 80gb.

I will be submitting a ticket to SAP tomorrow.

[Former Member]

Please keep us posted on what you hear back from your incident!

Thanks,
Missy