Distribution & Collection in BPC 10 functionality not working properly
We are working on SAP BPC 10 NW SP 04 and EPM Add-In SP 16 .NET 4 Framework.
We are using standard Offline Distribution & Collection functionality to create offline templates to be used by user for offline planning. Currently we have configured 3 steps for Distribution & Collection function.
In the first step
1. Download – The user will open the Distribution template, select the Entity and save the template(Open Distribution Template).
2. Distribution – In this step the user will distribute the template to users locally using folder location for that particular Entity using Distribution Wizard function.
3. Upload – In this step the user will collect the data from the offline distributed templates using Collection Function.
The issue which are facing while using this standard functionality is that when we first open the excel instance and download the offline template, and then try to distribute using Distribution wizard, the process gets stuck.(Kind of hanged). Instead if we open the excel again and this time directly distribute using the Distribution wizard then it distributes easily without any error.
Also one thing we observed were is if the Excel instance is opened for a long time for more than 2 mins, or if you perform some other activity first and then use Distribution function, then also the Distribution process gets stucked.
Please guide me on this if I am missing anything. Searched the forum and all documents available for this, dint get any insight on this.
Any help would be appreciated.
Thanks & Regards,