Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Data Manager Clear Package - VBA Automation Parameters

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,


Not what you were looking for? View more on this topic or Ask a question