Skip to Content
author's profile photo
Former Member

Performance Problems with Excel Client

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: BPC NW slow Performance (Expand, Refresh, Saving) - How to enhance it?, [BPC for Excel] Dimension clicked, then Excel hangs

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

Thanks in Advance

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • author's profile photo
    Former Member
    Posted on Apr 26, 2011 at 06:52 PM

    Whats the SP Level?

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 26, 2011 at 06:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded