Extremely slow Excel Export after 4.1 SP4 Patch 2

[Former Member]

Hello,

We've recently upgraded from BI 4.1 SP01 Patch 5 to BI 4.1 SP04 Patch 2.

When exporting larger datasets from AOLAP based on a sap bw 7.4 Patch 8 bex query, resulting in greater than 250K cells in XLSX, performance is very poor.

Before the upgrade, we could export 1m cells in under 40 seconds.  Now the same query's are taking over 8-10 minutes to export.  The query itself runs between 1-2 minutes.  And response is fairly quick to navigate pages/scroll.

In transaction sm50, we can see that there is communication between BI and BW during the entire process of export.  It appears to not be using cache and is rerunning the entire query.

We see the following programs being utilized by BW during the export process

CL_RSDM_READ_MASTER_DATA

CL_RSMD_RS_READ_MDATA

SAPMSSY1

SAPLSM02

SAPLRSBOLAP_BICS_PROVIDER

Has anyone else encountered a similar issue? 

[hariprasad_chennamadhavun]

Hi,

Could you please check below things:

1. did you find any differences in Memory settings for MDAS server between BI 4.1 SP01 Patch 5 and BI 4.1 SP04 Patch 2

2. Compare the multidimensional.services.export.cells.limit  property  in mdas.properties  file between BI4.1 SP01 Patch 5 and BI 4.1 SP04 Patch 2.

Please let me know the results.

Thanks,

Hari

[Former Member]

Hello,

We have now opened a SAP Message for this.  We will monitor this under message #0000055956

Thank you,

Nick

[richard_offenberger]

did you get a response?  We are having the same issue with 4.1 SP5 Patch 1

[Former Member]

We are in the midst of testing SP6.2 and it seems to have improved significantly.