Skip to Content
0
Jul 25, 2016 at 09:49 PM

VBA Macro Calling DMP in different model

97 Views

Hi,

I am on BPC 10.1 on SQL Server DB. I have a Excel worksheet which represents data in Model "A". Now in that worksheet, I have a button which executes a Data manager package (DMP) in Model B.

The VBA code for executing the DMP "COPY_BUDGET" is as follows. How can I specify the Model Name "B" in the connection parameter? When I am connected to Model A, I always get the error "Package Not Found". I have to manually change the model connection every time to execute the DMP through VBA macro. Is there a way to call/connect to the model via the VBA macro code?

Option Explicit

Dim client As New EPMAddInAutomation

Sub B_Copy()

client.DataManagerRunPackage "COPY_BUDGET", "Data Management", ""

End Sub

Sincerely,

Nicky