Skip to Content

Refreshing big EPM reports X times generate last endless(?) refresh

Hi all,

when refreshing X times (on a specific report X=3) a big report (>50k rows and 10/20 columns) the refresh is fine for the X-1 times but when we refresh for the Xth time the refresh get stuck on the "Report: Writing Report "Defaul Report" - Writing Headers..." phase. I waited for an hour (before taking down Excel) while usually it takes up to 3/4 minutes to refresh that specific report.

This doesn't happen when we follow this sequence:

1. Open Excel

2. Open and refresh Report

3. Close Excel

So basically it's seems that it's linked to some kind of issue with the Excel (Excel is on Citrix). Maybe some kind of memory issue?

***

System BPC 10.1 NW on DB HANA. Components:

SAP_BW740 - SP 14

CPMBPC810 - SP 09

EPM Add-in 10 SP 25

Thanks,

Michele

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 19, 2017 at 02:19 PM

    May be you have memory issues on the citrix server? Test the same with real pc, not using citrix...

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 25, 2017 at 02:01 PM

    Hi Vadim,

    I tried without going through citrix but the problem still persisits.

    Thanks,

    Michele

    Add comment
    10|10000 characters needed characters exceeded