How to trigger Collection Wizard in BPF activities- BPC 10.x?
There is no standard function to directly launch Collection Wizard via BPF activities. Therefore the user needs to add 'Collection Wizard' as a step of BPF
Please do the following:
1) First, create a report template with the VBA code in order to trigger Collection Wizard through the API 'OpenCollectionWizard'.
The following is an example in order to open the collection wizard automatically when the workbook is opened:
Private Sub Workbook_open()
Application.Run "EPMExecuteAPI", "OpenCollectionWizard"
2) Now in order to open the above report template please create a BPF activity.