EPM Function OpenDimensionAndMemberSelector SolutionName

[Former Member]

Hi all,

I am using BPC 10 and trying to use OpenDimensionAndMembeSelector in my VBA.

I have no idea what to put in for the solution name.

I have refer to guide but still din't know what to put.

I have my connectionString as

"_EPM_[SolutionName]_[abcserver.testing.com:8000]_[PLANNING]_[PLANNING_MODEL]"

This is what I am referring.

Parameter                      Description
ConnectionString as       Connection. Mandatory.
String                              Examples:
                                       u2022 "_EPM_[SolutionName]_[%server%:%port%]_[%environment%]_[%model%]"
                                       u2022 "_EPM_[SolutionName] _[%server%:%port%]_[%environment%]_[%model%]"
                                       u2022 "_EPM_LOCAL_[%oqy file name%]"

[JohnL · Accepted solution]

Try:

BPCMS10

Here's an example:

_EPM_BPCMS10_[http://localhost/SAP/BPC/]_[EnvShellCopy]_[Planning]

Thanks,

John

[Former Member · Accepted solution]

Hi John,

I manage to find another API - GetActiveConnection to get the connection string.

The example is as below.

Sub Button6_Click()

    Dim a As New FPMXLClient.TechnicalCategory
    Dim conn As String
    Dim b As New FPMXLClient.EPMAddInAutomation
    
    conn = b.GetActiveConnection(Sheet1)
    b.OpenDimensionAndMemberSelector (conn)
    
End Sub

[Former Member · Accepted solution]

Hi John,

I believe I have the syntax correct for the connection [have removed for security reasons] but I am still not able to get the API to work - what is the rest of the syntax for the call ....

Sub Click()

Application.Run "EPMExecuteAPI", "_EPM_BPCMS10_[http://localhost/SAP/BPC/]_[Housing]_[HPM]", "OpenDimensionAndMemberSelector, Entity"

End Sub

Any help would be appreciated.

Thanks

Justine