Skip to Content
0

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

Jul 19, 2017 at 01:20 PM

73

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Jul 19, 2017 at 02:19 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Michele Gaddi Jul 25, 2017 at 02:01 PM
0

Hi Vadim,

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

Thanks,

Michele

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Try to provide details, how it depends on the report size etc...

0

Hi Vadim,

we did some tests on the same report which has 18 dimension on the row axis and 1 dimension on the column axis (which extracts 2 members, so 2 columns):

1° Test - Filter A: 80k rows. On the second refresh in a row the report get stucked.

2° Test - Filter B: 6k rows. The report never get stucked. Tried more than 30 refresh in a row.

3° Test - Filter C: 30k rows. The report never get stucked. Tried more than 10 refresh in a row.

We did the same test on another report (which has less dimension on the row axis but more on the colum axis) and the result are similar.

Thanks,

Michele

0

You have to talk with basis team and perform server monitoring!

0