Skip to Content

VBA : Trigger DMP present in another model

Hi All,

System: BPC 10 NW

I am having an Excel template in CONSOLIDATION model.

I want to trigger an Exchange Rate Load package present in RATES model, using a Button/Macro combo.

How can we achieve this in VBA wherein we have option to pass connection string of another model to trigger the package?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 29 at 04:44 PM

    Do you need to pass any parameters? Prompts?

    Add comment
    10|10000 characters needed characters exceeded

    • Yes...looking to trigger silently with parameters being passed in Macro code

      Infact, currently I am able to trigger packages of the same Model by creating local XMLResponseFile with params via Macro and then using it to trigger package silently.

      Now, I need to find an option to trigger a package contained in RATES model, from a template contained in CONSOLIDATION model.

  • Jan 30 at 05:06 PM

    You can use SetActiveDataManagerConnection(string connectionString) to temporary change DM connection to Rates Model, run package in Rates and change connection back to Consolidation.

    Please read also my blog: https://blogs.sap.com/2017/06/16/simple-vba-function-to-pass-parameters-to-dm-packages/

    Add comment
    10|10000 characters needed characters exceeded