Data Manager Clear Package - VBA Automation Parameters

[Former Member]

Hello guys,

I have built an input sheet, where the user selects members from BPC dimensions (ACCDETAIL,ACCOUNT, ACTIVITY,ASSET, etc.). Next, the user clicks on the "Clear Data" button, which triggers a VBA macro (EPM_Clear). This macro should call the BPC clear package and clear the transactional data for the selected members.

I have two problems:

1) How do I pass on the previously selected parameters (i.e. which dimensions to clear) from VBA to the clear package?

2) When I use the following code, it says ‘Package not found’ .

VBA Code:

Private Sub RunPackage_Click()

Dim EPMObj As FPMXLClient.EPMAddInDMAutomation

Set EPMObj = New EPMAddInDMAutomation

EPMObj.DataManangerRunPackage ”Clear”, ”DataManagement”, ””

End Sub

Thank you and best regards,

Peter

[Shrikant_Jadhav]

Hi Peter,

Kindly refer yser guide  it says if you change value SELECTPROMPT () to "1" it will take into account the context member.

Go through the below link

page no 365

http://help.sap.com/businessobject/product_guides/boeo10/en/EPMofc_10_user_en.pdf

Shrikant