DM PACKAGE - TRIGGER FROM MACRO

[former_member623]

Hello,

BPC 10.1 NW,EPM ADDIN 28P1,HANA

i am triggering the run dm package from a button in excel.

I want to show the package view status dialog box only when user clicks on "Finish" button in run pkg dialog box. If user clicks on CANCEL button in run package dialog box i dont want to show view status dialog box. how to capture the cancel event in Run pkg dialog box?

below is my code.Now view status is always displayed(Finish or Cancel button in run dialog).

----------------------------------------------------------------

Dim EPMOBJ As New FPMXLClient.EPMAddInAutomation

Private Sub RUNPKG_Click()

EPMOBJ.DataManagerRunPackage "PKG1", "FINANCIAL", "" EPMOBJ.DataManagerOpenViewStatusDialog

Set EPMOBJ = Nothing

End Sub

---------------------------------------------------------------------------

[abhishja]

Please see the below step by step, we need datamanagerRunpackage "Import", "Data Manangment", The file, Transformation File before running Automatically (Finish)....

[abhishja]

Hi team,

I can not find https://www.sap.com/documents/2015/08/f8fac683-547c-0010-82c7-eda71af511fa.html as blank..

I need DatamanagerRunPacxkage Import path including Transformation file before running automatically (finish) and see the view status in VBA. Please help me to correct the code asap.

I tried my code but not working

Sub Runpackage()

Dim epm As New FPMXLClient.EPMAddInAutomation

epm.DataManagerRunPackage "Import", "Data Management", "HYPPLAN_SENG_TSG_AGM_BPC LoadFile_FY_122P12_24062022.txt", "GBL_FPADM", "DataFiles\FY22"

End Sub

Thanks,

Abhishek

[former_member186338]

It's a bad idea to post "pseudoanswer" in the 5+ year old question! Create a new question and I will help!

[former_member186338]

Please read https://www.sap.com/documents/2015/08/f8fac683-547c-0010-82c7-eda71af511fa.html

To run DM package without prompts...