Button to run DM script

[former_member414265]

Dear SAP BPC experts,

I would like to add a press button to the data entry layout which starts certain script in the data manager. The script does not have to be able to read the parameters of the context. My questions are the followings:

The excel sheet has to be ready for allowing macros and this has to be defined as macro friendly excel sheet as we save the excel sheet / template?

Which VBA function has to be used that can start reading the macro?

This had been VBA function MNU_eDATA_SELECTPACKAGE in SAP BPC 7.5 what is the relevant VBA function for this in SAP BPC 10.1?

Thanks for your help,

Tamas

[former_member186338 · Accepted solution]

Sorry, but why not to read standard EPM help?

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.28/en-US/f9c395f96faf1014878bae8cb...

Save file as xlsm

[former_member414265 · Accepted solution]

Vadim, thanks for your answer. your link is useful.

I have written my VBA code:

Private Sub Gomb_kattintás ()

DataManagerRunPackage(GASOLINE_BUTTON, Function, , CPMB/ICDATA)

End Sub

The VBA says that there is a syntach error in Private Sub Gomb_kattintás () in the first line.

What can it be the problem? any idea?

Thanks for your help

[former_member186338 · Accepted solution]

Sorry, but what do you mean by:

Private Sub Gomb_kattintás ()

DataManagerRunPackage(GASOLINE_BUTTON, Function, , CPMB/ICDATA)

End Sub

???????????????????????????????????????

You need some basic VBA training 😞

The correct Sub will be like:

Private Sub Gomb_kattintás ()
Dim epm As New FPMXLClient.EPMAddIn
epm.DataManagerRunPackage "packageId", "groupId", "teamId"
End Sub

[former_member414265 · Accepted solution]

Vadim Thanks for your help, but I am still getting an error message:

Please see the screen of this:

vba-problem.png

[former_member186338 · Accepted solution]

Sorry, but what you are doing???

epm.DataManagerRunPackage "packageId", "groupId", "teamId"

packageId= Name of the package

groupId=Name of the package group like: "Data Management"

teamId=For Company - empty!

Don't forget to add FPMXLClient in the VBA->Tools->References Menu!

[former_member414265]

Yes this has worked fine thanks for this Vadim.