Online Tutorials & Training Materials | STechies.com
Register Login
Advertisement

Trigger Collection Wizard in BPF activities- BPC 10.x

|| 0

Trigger Collection Wizard in BPF activities- BPC 10.x
Stechies

How to trigger Collection Wizard in BPF activities- BPC 10.x?

SOLUTION

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"

End Sub

2) Now in order to open the above report template please create a BPF activity.


Advertisement
Advertisement