Skip to Content

SAP 10NW BPC Collection not working

Jan 03 at 04:02 AM


avatar image


I have inherited a BPC system with some complex Forms. I am trying to set one of these up for offline distribution and collection. The distribution works fine. The collection fails with a message "an error has occurred while trying to save data for the workbook ..." Can anyone assist me in debugging this. Is there any sort of log that will allow me to see the cause. Does anyone have tips on common errors when running a collection.



collection.png (25.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Jan 03 at 07:51 AM

Sorry, but the error can be a result of incorrect template design.

I recommend to create very simple template and test collection.

10 |10000 characters needed characters left characters exceeded
Cliff Stinson Jan 05 at 03:17 AM

Hi Vadim,

I have made some progress and would appreciate your insight. I took a look at a schedule in the distributed folder. There I noticed

  • Save data was disabled
  • Edit report was disabled
  • There were no reports (e.g. Default Report) recognised.

If the schedule no longer contains a report then we should not be surprised that the collect step fails. So the question now is how is it that the EPM Add-in no longer recognizes the schedule as containing a report?

There are two things I can think of:

  • The schedule contains VBA
  • The schedule contains other sheets which also contain reports.

Can you offer suggestions as to a reason for this behavior?



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

For sure VBA can affect collection functionality. Please start with simple template!