cancel
Showing results for 
Search instead for 
Did you mean: 

Performance Problems with Excel Client

Former Member
0 Kudos

Hello all,

We installed BPC 7.5 SP7 NW on our customeru2019s system and experience massive performance problems on our local clients in combination with Excel and MS Office in general.

u2022When opening u201CMaintain Dimension Membersu201D it takes some time (approx. 2 min) to open the Excel Sheet with the elements. The u201CSave to Serveru201D as well as the u201CProcess Dimensionu201D also takes time to execute. When executing u201CProcess Dimensionu201D the sandbox appears and it takes approx 2 min until the Process popup window appears. The process itself has normal performance.

u2022We also experienced slow performance with the opening or saving dynamic templates dialogue in the Excel Client. It takes some time until this dialogue appears.

In general, we experience slow performance every time BPC is opening a pop up window! We also experience slow performance when opening a (non BPC) MS Office document.

In order to resolve this issue we looked at the following notes and forum entries:

Notes: 1541181, 1531059, 1507575, 1479436, 1448502, 1288810

Forum: ,

Can anybody give me tipps on how to solve this issue?

Thanks in Advance

Accepted Solutions (0)

Answers (2)

Answers (2)

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

If you are not up to SP06, I would suggest applying the support packages up to the level. We shipped a bunch of performance enhancements in SP06.

Regards,

Rich Heilman

Former Member
0 Kudos

Hello,

thanks for your answer. We already installed the latest SP 07 on the system.

Kind Regards

Former Member
0 Kudos

Hi Stephan,

We're experincing the same issue at a clients site on SP07 as well, did you resolve the issue?

Regards,

Markus

Former Member
0 Kudos

Hi Markus,

the SAP support finally asked us to install "Fiddler" to monitor the network traffic. From the log file we could see that the BPC Clients try to open the microsoft.com and verisign.com website. Our clients computers unfortunately don't have permanent Internet access on their computer, so the system was always waiting for a timeout.

To resolve the issue the clients IT network guys changed the proxy settings in the Internet Explorer and it worked.

We still don't have an answer from the SAP support of how to set this timeout to 0 or why the BPC clients try to open this sites.

I hope this helps!

Regards

Stephan Ruppert

Former Member
0 Kudos

Hi Stephan,

Thanks for that it solved our problem. My guess is that it has something to do with ssl certificates and revocation lists because the citrix server where we had this issue were trying to get them according to the windows event log. Just a guess though...

Regards,

Markus

LaurentBon
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi,

It will work if in IE, Advanced, Security you uncheck "Check for publisher's certificate revocation "

=======================

http://CSC3-2004-crl.verisign.com/CSC3-2004.crl

http://ocsp.verisign.com/MFEwTzBNMEswSTAJBgUrDgMCGgUABBQ%2FxkCfyHfJr7GQ6M658NRZ4SHo%2FAQUCPVR6Pv%2BP...

http://crl.verisign.com/pca3.crl

=========================

Regards to all,

Laurentiu Bogdan

Former Member
0 Kudos

Whats the SP Level?