Set macro SetActiveConnection

[rosanna_chiarazzo]

Hi Experts ,

I am trying to use macros to change the workbook connection to model via vba.

I need to use "setactiveconnection" but i don't know the arguments of this function.

Any idea of how to use it on BPC 10 NW?

Thank you in advance

Rosanna

[lucas_costa3 · Accepted solution]

Hi Rosanna,

First of all you need to "build" your connection link, for that update the values in bold.

_FPM_BPCNW10_[{your_server}:9014/sap/bpc/]_[{environment}]_[{model}]_[false]

Tip: To get the values you can use epm formulas and concatenate them:

A1	Fixed	_FPM_BPCNW10_[
A2	Formula	=EPMServer()
A3	Fixed	]_[
A4	Formula	=EPMEnvDatabaseID()
A5	Fixed	]_[
A6	Fixed	FINANCIALS
A7	Fixed	]_[false]

For the change connection basically use:

Sub test1()

    Dim EPM As New FPMXLClient.EPMAddInAutomation

    EPM.SetActiveConnection Sheet1, Range("A8").Value

End Sub

A8 is the cell with concatenated values.

Lucas

[rosanna_chiarazzo · Accepted solution]

Thanks a lot!