SAP 10NW BPC Collection not working

[former_member461591]

Hi,

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.

Thanks

Cliff

[former_member461591]

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?

Thanks

Cliff

[former_member186338]

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

[former_member186338]

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

I recommend to create very simple template and test collection.