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

[Former Member]

Hello,

Currently we're using SAP BO 4.0 SP6 and we have the same issue, when try to export a biggest report (10 MB) we need to wait about 5 / 10 minutes to take it.

I read the entire topic and if I understand still there is no a solution for next version, BO 4.1...

We'll create a ticket to SAP and wait for some luck

Thank you.

Pedro Amaro

[Former Member]

Hi Pedro,

As far as I am aware there is still no solution in 4.1... keep us posted on what you find out with submitting your incident.

We are currently on 4.1 SP4 Patch 1, starting to plan for an upgrade to either Patch 8 on SP4 or SP5 Patch 4.... I am hoping we can move to SP5 and pick up some other fixes we've been waiting for, though none relate to export to excel performance.

Good Luck!

-Missy

[Former Member]

Hi

We have recently upgraded from 4.1 SP3 to SP5 Patch 2.

And since the company still in on Java 6, we had to force all the users to HTML.

After the switch to HTML we have had a lot of complains form the users about Excel performance.

Sometimes they are able to save to Excel, and sometimes not.

We are not able to find a pattern.

When using applet with Crome or firefox we are able to save to Excel.

Regards

Einar

[Former Member]

i'm experiencing similar issues as yourself, the sap tech im working with tested this on SP5 Patch 3 with improved performance.   This patch has not been installed at any of the servers here, so i cannot verify it.  He will also be testing on SP5 patch 4 to see if it was not a one off success.

Maybe try testing SP5 Patch 3 and report back?

[Former Member]

Einar - Just for clarification - when using the HTML version, there is no 'Save as' to Excel.  Your only option is to 'Export as' and then can select pdf, excel, etc.

Is that what you are referring to? I wasn't sure, since I know in the applet, you actually have the option to do a "Save as" in excel format.  The Export in the HTML version does essentially the same thing (although with less notification of what is going on).

[Former Member]

Hi

We are on sp5 patch3 .

I am aware of the save as ( java ) and export ( HTML )

Our users with IE11 are having some problems, but on my pc with IE8 everything is ok.

But we need to investigate more on this, if it is the size that matters or...

Keep you informed..

Regards

Einar

[Former Member]

IE11 use edge mode

I'm a little confused, your original post said you were on SP5 patch 2.  You are now on SP5 patch 3?

If you are on SP5 Patch 3, has the excel performance improved?

[Former Member]

Hi

When we increased the maximumUploadFileSize from 10MB to 100MB on our BusinessObjects\tomcat everything was fine regarding excel, as long as the users use "export 2007".

Have had no complains from the users since this change.

Regards Einar.

[hbehrndt]

Dear Einar, can you share where / how you have changed the setting for maximumUploadFileSize?

Greetings,

Henrik