Skip to Content
0

VBA : Trigger DMP present in another model

Jan 29 at 04:34 PM

44

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Vadim Kalinin Jan 29 at 04:44 PM
0

Do you need to pass any parameters? Prompts?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

And silence...

0

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.

0
Vadim Kalinin Jan 30 at 05:06 PM
0

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/

Share
10 |10000 characters needed characters left characters exceeded